AutoParallel

Synopsis

[SQL]    AutoParallel=n

n is either 1 or 0. The default value is 1.

Description

When AutoParallel is enabled (n = 1), InterSystems SQL queries can use parallel processing to run more efficiently. In sharded environments, this means all queries are executed using parallel processing. In non-sharded environments, InterSystems SQL determines per-query whether to use parallel processing, based on the value of AutoParallelThreshold.

When this parameter is not enabled, all queries run in a single process.

If AdaptiveMode is enabled (set to 1) and AutoParallel is disabled, then Adaptive Mode overrides the AutoParallel setting and enables parallel processing.

Changing This Parameter

On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), select Execute queries in a single process to disable parallel processing.

To set the desired value for AutoParallel from the Terminal, use the SetOption(“AutoParallel”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.

You can also change AutoParallel with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).