0 Replies Latest reply on Aug 30, 2005 8:00 AM by Peter Doornbosch

    Why is on-find read-ahead strategy considered inefficient fo

    Peter Doornbosch Apprentice

      The JBoss Tuning guide states that

      This (on-find) strategy is effective for queries that return a small amount of data, but becomes very inefficient when trying to load a large result set into memory.

      I wonder why this strategy is inefficient for large data sets. When i have to process each bean in the result set, i would assume that loading all data with one query would be faster than several queries returning only part of the result.