How to disable Parallel Reload

In some situations, multi-threading database connections may lead to instability in the environment.  This article reviews how to disable the multi-threading of database connections using ODBC or OLE DB connections to test whether this provides more stability or not.

 

When running things with the EnableParallelReload set to a value of 1, the database connections may multi-thread, which will utilize more CPU cores than if the connections are single-threaded with the value of 0, which can cause stability issues if the server does not have many CPU cores in it but has many concurrent tasks.  Using the 0 setting will force single-thread condition, thus each reload process will only use a single CPU core for any database connections.  

For Publisher/QlikView Distribution Service

1. Open the Desktop client 
2. Click on Help menu
3. Click About option
4. Right click the product logo in the lower left corner of the resulting dialog 
5. In the Settings dialog, scroll to "EnableParallelReload" setting and left click 
6. In the Value block, change the Value to 0 from the default of 1 
7. Click the Set button
8. Click the Close button
9. Close the About QlikView dialog and run reload again

1. Use Windows File Browser to browse to: C:\Users\UserProfile\AppData\Roaming\QlikTech\QlikView
2. Open the Settings.ini file
3. Add the EnableParallelReload=0 setting under the [Settings 7] section
4. Save the file
5. Reopen the Desktop client and test