开发者

EntityManager's named query are slow where as JPAEntityManager's Expression query are faster

开发者 https://www.devze.com 2023-03-25 13:51 出处:网络
I am using Weblogic 10.3 and EJB3 with TopLinks(EclipseLinks) JPA implementation. I am facing an issue with my named queries, which are performing slow. However If I use EclipseLinks JPAEntityManager\

I am using Weblogic 10.3 and EJB3 with TopLinks(EclipseLinks) JPA implementation. I am facing an issue with my named queries, which are performing slow. However If I use EclipseLinks JPAEntityManager's Expression query to achieve same, its faster. I am not able to understand why my standard JPA named queries are slow. Has anyone faced similiar issue or Can someone explain the root cause of this issue.

Am I missing any basic tunn开发者_如何学Going or parameter???


That is very odd. Named queries should be in general faster as they are parsed once.

What is the specific query and its SQL? Are you comparing it to the same Expression query, or something different, which is its SQL?

Try enabling the EclipseLink PerformanceProfiler on the queries, or try using a Java profiler such as JProfiler.

0

精彩评论

暂无评论...
验证码 换一张
取 消