Re: Fast Inserts, Slow Updates
Innodb uses an insert buffer that allows IO for secondary indexes on update and insert to be deferred and then done in batch. This optimization is not done for delete. You state that the update process includes some deletes. This may be the reason for the performance difference if the table has secondary indexes.
http://www.google.com/search?q=insert+buffer+innodb
Subject
Views
Written By
Posted
4628
October 17, 2008 09:28AM
Re: Fast Inserts, Slow Updates
2042
October 20, 2008 10:15AM
1897
October 21, 2008 08:53AM
1912
October 23, 2008 07:16PM
1940
October 28, 2008 02:53AM
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.