On Mon, 22 Apr 2002 12:23:22 -0400 Mark Riehl <[EMAIL PROTECTED]> wrote:
> 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? I would probably use #2 since load tools are likely to be faster that separate INSERTs for each row, but try a couple tables and see what works best where you are. I haven't used MySQL, but if it lets you turn off AutoCommit you should. With Oracle, commit groups of 1 - 10 thousand seemed to work best, but that's another area for you to experiment with. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
