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
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to