MySQL Forums :: Performance :: Insert into table on duplicate key update - performance issue


Advanced Search

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.

Options: ReplyQuote


Subject Views Written By Posted
Insert into table on duplicate key update - performance issue 5795 Sreedevi Iyer 07/10/2009 01:43PM
Re: Insert into table on duplicate key update - performance issue 2715 Rick James 07/11/2009 03:16PM
Re: Insert into table on duplicate key update - performance issue 2668 Sreedevi Iyer 07/13/2009 06:55PM
Re: Insert into table on duplicate key update - performance issue 3134 Rick James 07/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.