|
|
|
This enhancement improves performance of batch insert operations on a transaction-controlled file when a number of inserts succeed but then one fails (say with a duplicate key error), especially when the data file has many indexes. This situation is equivalent to starting a transaction, establishing a savepoint, adding a number of records, then adding a record that fails with a duplicate key error, then restoring to the savepoint. The savepoint restore took a long time because of disk activity required to guarantee proper recoverability. A new strategy has been implemented that avoids most of the disk activity while guaranteeing recoverability.
