The other question is how often will you do this? Is it a one time shot? If so, do what is easiest to implement. If you know how do it using inserts, then do it. Don't debate it. The amount of time you might have saved will be long gone if you don't just act now. Once again, if this is a one time shot. If it isn't and you really need to speed up a nightly process.........well, then I'll just shut up.
-Ian "Herbold, John W." wrote: > > Mark, > > Try your hardest to use the LOAD procedure. Though I have not done it in > MYSQL yet, I have found with other databases, that the load procedures are > always faster than doing an insert a record at a time. I have taken a DB2 > database and used inserts to insert the records one at a time into a mysql > database, it took like 8 - 12 hours to run for around 15 million very wide > records (can't remember exact time, do to many loads ;-). > > John Herbold > IS Specialist/DBA > > -----Original Message----- > From: Mark Riehl [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 22, 2002 11:23 AM > To: [EMAIL PROTECTED] > Subject: Transferring from Access to MySQL > > All - We've got several Access databases that have ~2 million records and > each record has ~20 fields. > > Looking for the most efficient way to do this. As far as I can tell, I have > two options: > 1. Open a connection to each database, select * from the Access table, then > push each row into MySQL. > 2. Export the table from Access, then use a load data file to pull it into > MySQL. Each of the exported files is ~ 1 GB. > > Any other suggestions? How would you do this? > > Thanks, > Mark > > - > Mark Riehl > Agile Communications, Inc. > Email: [EMAIL PROTECTED]
