Hi, I have an findAll() query in my entityBean. I select large numbers of beans with this method (up to 30k). The bean has an compound PK (id (String) + date (Date)). The server.log shows the following query:
Executing SQL: SELECT blz, changeDate, flagDeletion, bankId FROM ShadowBLZ WHERE (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? ... And so on.... Is there a way to improve this ? I am using Jboss 3.2.2 + MySQL 4 Thanks in advance Stefan View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830940#3830940 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830940 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
