MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Insert into table on duplicate key update - performance issue
Posted by: Sreedevi Iyer
Date: July 10, 2009 01:43PM

Currently the insert into table on duplicate key update statement is taking 6 hours to insert/update 30 millions rows. How can I increase the performance of this query or is there any other alternatives to this problem.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Insert into table on duplicate key update - performance issue
6590
Sreedevi Iyer
July 10, 2009 01:43PM
Re: Insert into table on duplicate key update - performance issue
2980
Rick James
July 11, 2009 03:16PM
Re: Insert into table on duplicate key update - performance issue
3120
Sreedevi Iyer
July 13, 2009 06:55PM
Re: Insert into table on duplicate key update - performance issue
3716
Rick James
July 13, 2009 08:33PM


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.