On Mar 15, 2009, at 12:54 PM, Jeff Schmitz wrote:

Hello,
I was wondering if there were a way to specify a qualifier on a to- many relationship in a batch fetch (ERXBatchFetchUtilities) or prefetch command? I see you can specify the key paths, but what if I only want to pre/batch fetch rows based on some qualifier for a key path, instead of just getting them all pre-loaded? Or would the possible time savings to do this not worth the effort? What if say you have 10000 total rows to be fetched, but you only really need 5000 of them based on some qualifier?

That is not what prefetching and batch fetching are for. You want a qualified fetch, so you will need to make another fetch spec. BUT if you have A ->> B and fetch A and a subset of the B relationship, if you ever touch a.b() in code, the rest of the objects will be fetched as faults.

Chuck

--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects






_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to