Deferring Index Updates
From InterBase
Go Up to Application Design Techniques
Inserting and updating data requires indexes to be updated, which can cause performance to suffer during INSERT
or UPDATE
operations.
To minimize the performance hit during INSERT
or UPDATE
operations, consider temporarily disabling indexes during high-volume INSERT
operations. Make sure to re-enable the indexes afterwards. This approach only requires the indexes to rebalance once for all the inserted data.