Re: Needed: An Efficient, reliable and smart way to copy data from one DB to another

Hi Robert,

Thanks.

"Robert Klemme" <bob.news@xxxxxxx> wrote in message
news:3uj731F116anbU1@xxxxxxxxxxxxxxxxx
> Just set the parameters as usual then do addBatch() instead of execute()
> and call execute() only every n records.
>
>> I do not know if either of these options I'm considering would improve
>> things. Are there any other options I ought to consider? I need to
>> get this done since I will need to deploy my application on a linux
>> box.
>
> I'd start with using batch mode of the prepared statement. That's the
> simplest change to your code, should improve things and is generally a
> good idea for such an app.
>
I have done this, started the program before lunch and it is still running.

> Apart from that you probably first have to determine where time is spent.
> Could be your network or a slow machine with the MySQL db on etc.
>
The network isn't an issue because right now both databases are sitting on
the same machine. And the machine is reasonably quick, with a 3.2 GHz P-IV
and 1GB of RAM.

I think Thomas might be on to something with regard to the indeces.

But I am intrigued by Hal's suggestion about exporting tables from the
Access DB through a DNS and then importing them into MySQL. After my
program finishes, I'll give that a try. Had I known about this option, this
task would have been done more than a week ago! I'll spend most of tomorrow
looking for information in the MySQL documentation about how to import
existing tables into a database.

Thanks again,

Ted

--
R.E. (Ted) Byers, Ph.D., Ed.D.
R & D Decision Support Solutions
http://www.randddecisionsupportsolutions.com/
Healthy Living Through Informed Decision Making


.