MySQL Forums
Forum List  »  Perl

perl script performs poorly - please advise
Posted by: nino walker
Date: April 07, 2009 12:22PM

I have a perl script that uses DBI to connect to a MySQL db. On an average run it will need to execute about 500K SQL statements (a mix of Select/Insert/update/delete)

the script can take 8+ hours to run, but if I have it generate a .sql file for the same transactions, and run the .sql file against the same server it finishes in a few minutes.

I'm look for any direction on what I'm missing. For the time being, the two step process works, but I would like to consolidate the process.

Options: ReplyQuote


Subject
Written By
Posted
perl script performs poorly - please advise
April 07, 2009 12:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.