[jboss-user] [JBoss Seam] - performance of EntityQuery
do-not-reply at jboss.com
Tue Nov 20 15:30:54 EST 2007
I generated my JBoss seam application with 'seam generate-entities' and noticed the following:
- Every time I walk thru a table (via paging) a sql query count(*) from <table? is performed.
For tables with a large amount of data this count(*) is time consuming. I already notices that there are no hints for count queries (for caching the result via hibernate).
Is there another way to overcome the problem that for every page a count(*) call is done on the database?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4106541#4106541
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4106541
More information about the jboss-user