There is no size() method on ResultSet. And no way to know the number of elements
thrown away with limit/offset.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3844907#3844907
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=repl
"SilvioMatthes" wrote : Hello again,
| anonymous wrote : If Jboss needs to count the number of records in the DB, then
the resultset will need to be traversed
|
| I don't think so. JBoss calls the database without any LIMIT/OFFSET-clauses and
gets back a collection/resultset of primary-key
Hello again,
anonymous wrote : If Jboss needs to count the number of records in the DB, then the
resultset will need to be traversed
I don't think so. JBoss calls the database without any LIMIT/OFFSET-clauses and gets
back a collection/resultset of primary-keys. It should only do a size() or som
I think there is no alternative but using count(*).
If Jboss needs to count the number of records in the DB, then the resultset will need
to be traversed, causing an even bigger bottleneck.
Joachim
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3844657#3844657