Syntactic Confectionery Delight | |
PerlMonks |
Re: Script die without warning while getting result from DBIby mpeppler (Vicar) |
on Jan 04, 2008 at 08:32 UTC ( [id://660388]=note: print w/replies, xml ) | Need Help?? |
I'm with perrin on this one - loading 30 million rows into memory seems guaranteed to fail, even if you have 8GB of RAM (after all, 8GB means about 266 bytes for each row if you have 30 million rows, and that's discounting all other RAM usage on the machine!) I would strongly suggest that you review your algorithm to avoid fetching the whole result set in one go. Michael
In Section
Seekers of Perl Wisdom
|
|