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.

Advance To: