good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
$dbh->prepare() and execute() take too long?by jbrugger (Parson) |
on Mar 07, 2006 at 06:41 UTC ( [id://534840]=perlquestion: print w/replies, xml ) | Need Help?? |
jbrugger has asked for the wisdom of the Perl Monks concerning the following question:
Oh wise Perl magicians I have a query that looks something like this : The 'explain' shows a good and nice run (no full table scans), and in mySQL it takes about 3 seconds to run (about 130.000 records) using mysql -u user -p database < q.sql > output.txt When doing this from whithin Perl however, It takes about 12 seconds to run (Only the prepare and the execute, i did not even loop over the resultset). Any idea on how to speed this up? Whit a smaller resultset, it takes about .003 seconds to prepare / execute. I know DBI should be able to do mutch better, any ideas on how i can get a better result? Thanks. ps. I run this on an UML (user mode linux), so there is a lot of overhead in the disk io, however, the same problem occurs on a 'normal' debian distribution, the difference is big. (2 sec - 8 sec) ps.ps. The resultset of the query looks like this:
Ah FOUND IT!!! Here is the answer!!! <Reveal this spoiler or all in this thread>
"We all agree on the necessity of compromise. We just can't agree on when it's necessary to compromise." - Larry Wall.
Back to
Seekers of Perl Wisdom
|
|