Re: [eclipselink-users] Batch read question: controlling no. ofsubqueri

[Laird Nelson <ljnelson@xxxxxxxxx>]

On Tue, Apr 7, 2009 at 8:14 AM, Gordon Yorke <gordon.yorke@xxxxxxxxxx> wrote:

Laird,

Now, that still means that the total number of SQL queries is proportional to the size of the original OQL finder query's result list (if you get ten Items back, you will have run the Item finder query, obviously, and then you'll run at most 10 more subqueries--one each time you access an Items getSellers() method).  Right?

No, With batch reading set EclipseLink will execute only one more query reading back all of the related Sellers for the initially queried Items.  So you read all of the data in two queries.  --Gordon

Great; that's exactly what I wanted to hear.

Best,
Laird