Database Administrator Guide > Database Administrator Guide > Updating Data in X100 Tables > How to Avoid Propagation
Was this helpful?
How to Avoid Propagation
During batch operations X100 automatically propagates the changes buffered in memory to the disk-resident table. Because such propagation can be costly in terms of time and resources, it is best to avoid frequent propagation to large tables by using one of the following approaches:
• Consider disabling automatic propagation by setting [system] update_propagation = false.
• For large tables with frequent inserts, consider using RAW storage format (See Raw Table Storage Format).
• For tables with a clustered index, keep the volume of data changed below what will easily fit in RAM.
Note:  The data changes buffered in memory are not compressed.
• If a clustered index must be used for query performance, stage batches of inserts and deletes in one or more separate tables and use the MODIFY...TO COMBINE Statement--Merge and Update Data to add them to the table.
• Enforce propagation at a convenient moment, as described in MODIFY...TO COMBINE Statement--Merge and Update Data.
Last modified date: 11/09/2022