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
