Re: Questions on Fetching with Conditions
Sacha Michel Mallais <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <[email protected]> |
On Mar 7, 2006, at 12:10 PM, Randy Wigginton wrote: > I have a similar question. How can I tell WO NOT to load a column > all the time? I have a very large (BLOB) column. If I attempt to > load a range of objects with that column included, I end up running > out of memory. I would like to load the rest of the row, but only > fault in that data by request. Is there an approved manner of > doing this? The way I usually do it is to put the blob in a separate table/entity -- I would call this the "best practice". Another possibility is to move the blob out of the database altogether. If neither of those grabs your fancy, then you could create two entities in EOModeler, one which includes the blob and another that doesn't (both pointing to the same table -- yes, that's allowed). Of course, you'll have to do some gymnastics in code to make sure you don't get the two confused... sacha -- Sacha Michel Mallais Senior Developer / President Global Village Consulting Inc. http://www.global-village.net/ PGP Key ID: 7D757B65 AIM: smallais "If people stop copying my music, I should start to worry." -- Frank Zappa