perl script performs poorly - please advise
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.
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.