http://qs321.pair.com?node_id=660388


in reply to Script die without warning while getting result from DBI

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