Queries in Query Agent are slow to execute.
Article ID: KB0086252
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
Description:
===========
Queries in Query Agent slow to execute.
Environment:
===========
o BusinessEvents 3.0.2
o All Operating Systems
Symptoms:
=========
The Query Engine downloads all items into the Query Engine and then performs filtering locally (older versions uses Javaassist) resulting in slow queries.
Cause:
======
see Symptoms
Resolution:
========
Add the TRA parameter below to perform the filter (where clause) on the Distributed Cache and load the filtered results only into the Query Engine.
java.property.com.tibco.cep.query.executionplan.factory=composite
Description:
===========
Queries in Query Agent slow to execute.
Environment:
===========
o BusinessEvents 3.0.2
o All Operating Systems
Symptoms:
=========
The Query Engine downloads all items into the Query Engine and then performs filtering locally (older versions uses Javaassist) resulting in slow queries.
Cause:
======
see Symptoms
Resolution:
========
Add the TRA parameter below to perform the filter (where clause) on the Distributed Cache and load the filtered results only into the Query Engine.
java.property.com.tibco.cep.query.executionplan.factory=composite
Issue/Introduction
Queries in Query Agent are slow to execute.
Feedback
Yes
No
Powered by
