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.