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.
Subject
Views
Written By
Posted
2694
April 15, 2005 11:49AM
Re: INSERT requires 2 reads?
1950
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.