I have a PHP script that is reading data from a set of FoxPro tables and inputting it into a parallel set of MySQL tables (in a single MySQL database). The process goes in this order:
- Clear MySQL tables
- Read through each record in each FoxPro table, inserting it into the corresponding MySQL table along the way
Obviously for a small amount of records, this works fine. However, this process is now working with hundreds if not thousands of statements and it's taking a much longer time to complete.
Is there a way for PHP / MySQL to queue these statements up and batch run them all at one time? It would also be helpful if it could lock the database prior to running this "batch transaction". Not sure what's possible here and what isn't.