Re: batch fetching
Re: batch fetching
- Subject: Re: batch fetching
- From: Mark Ritchie <email@hidden>
- Date: Sat, 2 Dec 2006 23:15:53 -0500
Hi Mike!
On 2-Dec-06, at 11:45 AM, Mike Schrag wrote: But just so I don't make batchFetchRelationship's head too big, it is still EOF, so it will make an enormous EOOrQualifier of the companies rather than a slightly nicer In-Set qualifier.
IIRC, that's because batchFetchRelationship dates to the Obj-C days and the in-set operator wasn't as commonly supported by databases then as it is today. The massive use of 'or' statements has sometimes caused me grief when there are a lot of join conditions and the length of the SQL statement exceeds what the database can handle. The use of an in-set operator would help in that specific case. Overall, I'm not sure if an in-set operator would be any faster then 'or' statements. In fact, IIRC some databases convert the in-set operator to 'or' statements before evaluation anyways.
Regards, Mark __ Mark Ritchie Toronto Ontario Canada
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden