|
|
|
Bulk addition is a great technique for quickly loading data into tables by allowing large blocks of records to be written into tables followed by a final index rebuild.
Bulk addition is enabled with the <bulkaddition> option in your local FairCom RTG ctree.conf configuration file. When <bulkaddition> is enabled, only data records are written and the keys later updated in one single index rebuild operation after the file is closed.
Previously the index rebuild routine used by FairCom RTG bulk addition scanned the data file for errors by default. In the case of bulk addition operations this data file scan is not necessary as indexes are only rebuilt to re-sync keys and not to find and fix file corruptions. Therefore, skipping the data scan phase of index rebuilds saves substantial time.
