I have a large table (100 million rows) that are children to a parent
table of about 500,000 rows. I want to load children and iterating
through them to calculate statistics about them and then store those
stats on the parent file. I'm using Frontbase and have the indexes for
the parent (PK and the lookup column) set as "preserve time", per
Frontbase recommendations.
Problem is timings show it to take about 10 seconds per 1,000 children
to load.
I have tried this two ways.
NSArray anArray = parent.children();
and
NSArray anArray = EOUtilities.objectsWithFetchSpecification...;
The time is burnt, as expected, as soon as the faults are triggered to
retrieve the data. I've got the fields being used for the lookup in
the fetchspec indexed and have adjusted the Frontbase cache (with no
real effect).
What are the methods of faulting that could improve this? Would people
recommend changes in EOModel (faulting, caching, etc.) or better to
focus on Frontbase?
Regards,
Drew
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
