Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Script die without warning while getting result from DBI

by mpeppler (Vicar)
on Jan 04, 2008 at 08:32 UTC ( [id://660388]=note: print w/replies, xml ) Need Help??


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

  • Comment on Re: Script die without warning while getting result from DBI

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://660388]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others taking refuge in the Monastery: (4)
As of 2024-04-25 05:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found