BQL performance while processing queries

BQL performance while processing queries

book

Article ID: KB0087644

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
===========
BQL performance while processing queries

Environment:
===========
TIBCO BusinessEvents 5.1.1 HF5
All Operating Systems

Symptoms :
===========
While processing a query in BQL the BQL returns the result after a considerable amount of time indicating slow performance of query execution.

Cause :
===========
BQL is an external tool for verifying data inside the cache and should not be used in production projects for performance intensive querying .

Resolution:
===========
The same queries which take a considerable amount of time in BQL when used in dynamic query sessions inside BusinessEvents code will give much better performance and is recommended for production usage .

Issue/Introduction

BQL performance while processing queries