OK, I wrote a little program in java to retrieve the data from the MS Access
database and insert it into the MySQL database. Retrieving even the largest
table, about 7700 records, from the Acceess database takes only a few
minutes, but inserting the data into the corresponding table in MySQL takes
hours. I don't understand why, but I suspect that it may be related to the
fact I get the data from Access as a single block of data (one SELECT
statement), and I insert the records one at a time into MySQL.
For each table, I created a ...