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