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 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3844657 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user