I am using JBOSS 3.0.0. I am trying to use read-ahead with the strategy being on-find. I have set the eager-loading appropriately in the bean to load up the appropriate fields. I have also specified read-ahead strategy in the query section. I have to get a collection based on a query and iterate through all its elements. That is the reason I am using the on-find strategy.
The SQL that I see getting generated, is not that for on-find but that of on-load.
The sql is something like: select a, b, c from d where (id=?) OR (id=?) OR (id=?) and so on.
This query is causing my perforamce to go down.
What I am trying to do is to read all the rows from the DB that meet the specified criteria in one shot and with minimal stuff in my where clause.