Re: EOQualifier Question
Re: EOQualifier Question
- Subject: Re: EOQualifier Question
- From: Art Isbell <email@hidden>
- Date: Wed, 24 Mar 2004 12:40:53 -1000
On Mar 24, 2004, at 11:23 AM, James Cicenia wrote:
> I am not doing this qualifier against the sql but against the array
> from a relationship..
> Does that relationship follow the key paths?
>
> NSMutableArray results =
> (NSMutableArray) EOQualifier.filteredArrayWithQualifier(
> portfolio.projects(),andQualifier);
>
> or does it have to be a fetch?
Should work in either case. But just because the portfolio.projects()
objects are in-memory doesn't mean that filtering the array won't
result in DB accesses. In following the qualifier key path, any object
for which a snapshot doesn't exist will be fetched. This could result
in many individual fetches. If the to-many relationships in the key
path have batch faulting set to a non-zero value, the number of
database accesses could be reduced. This is another reason why
watching the generated SQL is important in tuning for performance.
Aloha,
Art
[demime 0.98b removed an attachment of type application/pkcs7-signature which had a name of smime.p7s]
_______________________________________________
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.