Re: specifying number of rows to fetch
Re: specifying number of rows to fetch
- Subject: Re: specifying number of rows to fetch
- From: John Gilmore-Baldwin <email@hidden>
- Date: Mon, 28 Jun 2004 15:57:58 -0700
I'm not sure there's a reliable way to do what you want without
resorting to database specific syntax and doing a raw row fetch with
custom sql.
There's also a question about accuracy. If you fetch rows 1-100, and
while you're looking at them "row" 50 is deleted, then you fetch rows
101-200, will a row get skipped? The answer to this question could
depend on your sort key, and whether it's unique. Similar issue for
inserts while looking at the data fetching the same row twice.
I'd suggest you consider limiting the result set to a certain number of
rows, and letting the users narrow their search if they get more
results (if this is feasible for you application).
John Gilmore-Baldwin
On Jun 28, 2004, at 4:55 AM, Goh Keng Boon wrote:
Actually i would like to fetch only 100 records into memory every
time, not so much on the ordering.
KB
_______________________________________________
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.