Re: java.lang.OutOfMemoryError with WODisplayGroup
Re: java.lang.OutOfMemoryError with WODisplayGroup
- Subject: Re: java.lang.OutOfMemoryError with WODisplayGroup
- From: Chuck Hill <email@hidden>
- Date: Wed, 08 Oct 2003 20:03:56 -0700
Hi Denis,
At 03:21 PM 09/10/2003 +1300, Denis Stanton wrote:
>On Thursday, October 9, 2003, at 02:10 PM, Art Isbell wrote:
>
>> ... There's no batching capability in SQL as far as I know, so EOF
>> behaves like SQL in this respect.
>
>I guess what I was hoping for (without really reasoning it out) was
>that the DisplayGroup would automatically figure out the SQL required
>to fetch only the records required to display the current batch. You
>don't need to explain the fallacy in this, I'm getting it.
>
While I fully agree with Art's advice that fetching less is the right
solution, I will point out that Project Wonder has something that will sort
of do what you want. I don't recall the name but I'm pretty sure that Max
Muller wrote it. What it does, from memory, is to fetch all the primary
keys for all of the rows. Then it fetches the objects in batches using a
sub-set of the primary keys in an SQL IN clause. I think it had some
limitations, but it might be useful to you.
>In my application it looks like the simple work-around is going to be
>to display the alphabet A-Z across the page and ask the user to select
>one letter at a time, where that letter will be matched against some
>characteristic that is spread across the file. Probably the first
>letter of the customer name will be enough to break the file into
>chunks. This screen was only going to be used on rare occasions to
>locate historic information. I'm going to have to provide some
>alternative search methods, rather than just a batched list with
>multiple sorts, as I hoped.
>
From a user's point of view I'd think that some alternate search methods
would be preferrable to being asked to page through several thousand
records looking for something. Personally, my eyes would glaze over after
the first few hundred. But I have a short attention span. :-)
Chuck
--
Chuck Hill email@hidden
Global Village Consulting Inc. http://www.global-village.net
_______________________________________________
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.