WAS v8.5 > Develop applications > Develop Dynamic and EJB query > Develop applications that use EJB query > Use the dynamic query service

Dynamic query performance considerations

While using a dynamic query can be convenient, there are times when it can have an impact on the application performance.


General performance considerations

Use of the following elements in your dynamic query can diminish application performance somewhat:

When assessing application performance, you should also be aware that dynamic queries share connections with the persistence manager. Consequently, an application that includes a mixture of finder methods, CMR navigation, and dynamic queries relies on a single shared connection between the persistence manager and the dynamic query service to perform these tasks.


Limiting the return collection size


Related concepts:

EJB query language


Related


Use EJB query


+

Search Tips   |   Advanced Search