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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...