You are not specifying how are you doing the comparison, but here is my 2 cents:
Import the foxpro tables into the MySQL database and then you'll be able to do
your update in a single SQL statement, which, even for that many records would
take some only a few seconds, then delete th imported da
I have an app that basically compares a old foxpro database to a MySQL
database. If the time-stamp does not match up then it updates the MySQL. My
question is, is there a more officiant way of doing the MySQL update. I am
using pandas itterrows() then doing an update query on each iteration. The
