Fetch Specs and Limits
Fetch Specs and Limits
- Subject: Fetch Specs and Limits
- From: Greg <email@hidden>
- Date: Thu, 12 May 2005 08:57:27 +1000
After reading the previous thread on OutOfMemoryExceptions when
dealing with large data sets getting fetched. I was looking at
optimising my search results component to be more effecient.
Currently because there is on about 8000 records to search at the
moment, it is not really an issue, but with the system growing it
will become one in the future.
I was looking at EOFetchSpecification on how to fetch only a certain
number of results. It has the setFetchLimit method, but it doesn't
have a setStartAtIndex or something similar. What I am wanting to do
is just to fetch the results of the search for say the first 20
records. If there is 200 records then there will be 10 pages of
results, when the user clicks to see the second page of results, I
would want to make a fetch spec to return the results starting at
index 21 and limit it to 20 results. I cannot see how I can do this.
Do I need to write the SQL to do it?
Any information is greatly appreciated.
Regards,
Greg
_______________________________________________
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