I'm using JBoss 3.2.5 with CMP beans and I have noticed that when I query a database using primary keys (direct access) is quite fast, but when I search a hole table and I need to bring more than 50 records is gets too slow. Is there any way to do it faster? The tables are not very big (less than 10000).
Thanks View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3854413#3854413 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3854413 ------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
