Hello,
We are using a dynamic query in a CMP bean. The read-ahead is set to the default on-load rather than on-find.
We have noticed that when the finder returns the primary keys, and the session starts accessing the entities, n SQL's are fired to load the entities rather than one big one with the primary keys OR'ed.
We are using 3.2.1 and this is killing our performance.
Thanks for your help.
T Hammoud
Chicagi