MySQL Forums
Forum List  »  Other Migration

Nightly update process too slow
Posted by: Graham Davis
Date: October 19, 2011 06:44AM

I have a data migration process that runs nightly to update a mysql database (version 5.0.90) with about 71,000 records.  The sending database is in Texas and the receiving in Kansas.  I am currently sending the records one at at time via a stored proc, but it is long and slow taking about 6 hours to complete.

I tried to speed up the process using a multi value insert....

Insert into table name (a,b,c)
values (a1,b1,c1),
(a2,b2,c2),
(a3,b3,c3),..........

but the data contains things like apostrophes, causing the insert to fail.

Can someone please tell me a faster and more efficient way to do this? The processing time is killing us!



Edited 1 time(s). Last edit at 10/19/2011 06:45AM by Graham Davis.

Options: ReplyQuote


Subject
Views
Written By
Posted
Nightly update process too slow
3990
October 19, 2011 06:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.