Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Script die without warning while getting result from DBI

by mpeppler (Vicar)
on Jan 04, 2008 at 08:32 UTC ( #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
Node Status?
node history
Node Type: note [id://660388]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (5)
As of 2020-10-29 14:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (271 votes). Check out past polls.

    Notices?