SuppressThreading

The SuppressThreading parameter determines whether or not to use a single thread to read data from and write data back to the database. These settings are available:

Value	Description
0	(Default) Uses two threads: one thread to read data from the database and a second thread to write data back to the database. By default, on the Set Properties page, the check box for this parameter is not selected.
1	Uses a single thread to read data from and write data back to the database

If you use a single thread, your consolidation is serialized on each sheet of data in a fact table.

Best Practice: For computers with dual processors or greater, there may be a performance gain by running a consolidation with two threads. To determine which setting produces the best performance, we recommend running a consolidation with and without two threads.

Type: Scripting parameter, Engine property