MySQL Forums
Forum List  »  Performance

Re: INSERT performance
Posted by: James Day
Date: December 20, 2004 04:21PM

If using InnoDB, are you wrapping the updates in a transaction? If not, try that to ensure that you don't get one log write per row update.

For all engines, if you have one parent row and many children in the other tables, try combining the updates to one row into a single insert or update statement. More comments on "speed of insert statements" are in the manual. Similar section for update.

Options: ReplyQuote


Subject
Views
Written By
Posted
6882
December 11, 2004 08:33AM
2838
December 15, 2004 01:56PM
2626
December 20, 2004 12:58PM
Re: INSERT performance
2490
December 20, 2004 04:21PM


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.