[jboss-user] [JBoss Seam] - performance of EntityQuery

[mark.wigmans]

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