0 Replies Latest reply on Apr 24, 2003 9:03 PM by thammoud

    read-ahead dynamic CMP queries

    thammoud

      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