Re: can I use fetch spec to filter an array?
Re: can I use fetch spec to filter an array?
- Subject: Re: can I use fetch spec to filter an array?
- From: Denis Stanton <email@hidden>
- Date: Wed, 31 Dec 2003 14:02:23 +1300
On Wednesday, December 31, 2003, at 01:33 PM, Jonathan Rochkind wrote:
In general, I consider such a raw SQL solution to be a last resort.
My thinking too. I don't think it will come to that.
Another thing to consider: if an Agent has a to-many relationship to
Booking, and there are a HUGE number of bookings at the destination of
a particular relationship, only a small subset of which you are
actually interested in---then don't use the relationship. Instead
actually fetch these bookings yourself with an EOFetchSpecification,
fetching only the bookings you are interested in, within (or even
accross) a particular agent. You may already be doing that, apologies
if I'm stating the obvious.
Not at all. I am thinking around those possibilities and alternatives
are welcome. In this particular case, and from my understanding of the
way my client will use this report, I don't think this suggestion
applies. It seems that each relationship will typically return less
than a dozen items with peaks of about 250. Of these maybe half will be
discarded for a given report.
Denis
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.