Re: Out-of-memory with large dataset
Re: Out-of-memory with large dataset
- Subject: Re: Out-of-memory with large dataset
- From: David LeBer <email@hidden>
- Date: Wed, 11 May 2005 11:44:37 -0400
On May 11, 2005, at 11:36 AM, Jan Willem Luiten wrote:
Hello,
I'm using WO 5.2 in combination with PostgreSQL 8. I have a table
containing well over 600.000 tuples. With a WODisplayGroup on this
table I get an out of memory error. Anyone on the list knows wether
this would happen with other DB's as well or is this a problem
between EOF and PostgreSQL?
Any hints on how to solve this are more than welcome.
Kind regards,
Uh, yeah.
WODisplayGroup will fetch *everything* into memory (unless you
qualify the fetch). Probably not what you want to do with 600,000 rows.
Solutions:
- Don't allow your WODisplayGroup to load automatically. Make the
user qualify the fetch first.
- Roll your own batching/sorting/displaying controller that batch
fetches.
- Look at ERXBatchingDisplayGroup from ProjectWONDER (caveat: I seem
to remember there being issues with PostgreSQL and this component,
search the list)
;david
--
David LeBer
Codebase Software Systems
site: http://www.codebase.ca
blog: http://david.codebase.ca
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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