MySQL Forums
Forum List  »  InnoDB

Re: INSERT requires 2 reads?
Posted by: James Day
Date: April 24, 2005 03:03PM

InnoDB will need to read the clustered index page and the page for any indexes it needs to update. If you can sort your updates so they are in primary key order that may help, since it'll increase the number read by each page read. Sorting before inserting can help.

Options: ReplyQuote

Written By
April 15, 2005 11:49AM
Re: INSERT requires 2 reads?
April 24, 2005 03:03PM

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.