Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re: DBI speed up needed on MySQLby bart (Canon) |
on May 08, 2005 at 09:50 UTC ( [id://454991]=note: print w/replies, xml ) | Need Help?? |
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.
In Section
Seekers of Perl Wisdom
|
|