Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: DBI speed up needed on MySQL

by bart (Canon)
on May 08, 2005 at 09:50 UTC ( #454991=note: print w/ replies, xml ) Need Help??


in reply to DBI speed up needed on MySQL

This being Mysql, I think you might have a memory issue. IIRC, Mysql is notorious for fetching all rows for a query, before it even starts to return the first one. If that's the case, 400000 rows of 200 columns is a lot of memory. So maybe your computer is just trashing about.

But perhaps they fixed it in a newer Mysql version. Or maybe there's a setting to tweak Mysql, so that it doesn't do that.


Comment on Re: DBI speed up needed on MySQL

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (13)
As of 2015-07-29 14:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (263 votes), past polls