Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: DBI speed up needed on MySQL

by CountZero (Bishop)
on May 08, 2005 at 08:53 UTC ( #454989=note: print w/ replies, xml ) Need Help??


in reply to DBI speed up needed on MySQL

print "It takes me over 30 minutes to print this!!!\n";

Are you printing 40_000 records of 200 fields each to your screen? Or are you doing something else to them? Perhaps that's where the long processing time is?

Do you save all the (processed) data in some variables/arrays/hashes? That could eat up your memory very fast and then your system starts swapping to disk and performance degrades.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law


Comment on Re: DBI speed up needed on MySQL
Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (9)
As of 2014-11-27 03:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (178 votes), past polls