Re: Row Cache / Fault
Re: Row Cache / Fault
- Subject: Re: Row Cache / Fault
- From: Alexander Spohr <email@hidden>
- Date: Thu, 17 Jan 2008 12:03:04 +0100
Hey Drew,
Am 17.01.2008 um 00:14 schrieb Drew Thoeni:
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();
This should trigger one fault, not many.
NSArray anArray = EOUtilities.objectsWithFetchSpecification...;
And this should trigger no fault at all.
The time is burnt, as expected, as soon as the faults are triggered
to retrieve the data.
So what (multiple) faults are getting fired here?
Any loops that do something wrong?
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?
BatchFetching. But my feeling is that this is not your current
problem. 10 secs for just 1000 rows from just one parent (read: one
foreign key value) is wrong.
Try to fetch all children of one parent from some tool using SQL. If
that takes 10 seconds your Frontbase has a problem with your 100
million rows.
atze
_______________________________________________
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