XP is just a number | |
PerlMonks |
Re: DBI: How to update 150K records efficientlyby Juerd (Abbot) |
on Mar 31, 2008 at 14:15 UTC ( [id://677525]=note: print w/replies, xml ) | Need Help?? |
Likely to be a significant slowdown, is the SQL abstraction done by SQL::Abstract. By including this in the loop, you make SQL::Abstract work once for each record. The solution would be to get back to basics by writing the SQL yourself.
By the way, you should not call your DBIx::Simple $dbh. This is the common name for DBI objects, and objects of classes that inherit from DBI. Using the name $dbh for DBIx::Simple objects is kind of confusing. I suggest calling it $db instead.
In Section
Seekers of Perl Wisdom
|
|