Skip to main content

AutoParallelThreshold

Set the threshold for parallel processing.

Synopsis

[SQL]    AutoParallelThreshold=n

n is any nonnegative integer. The default value is 3200.

Description

The higher n is, the lower the chance that an InterSystems SQL query executes using parallel processing. The value n corresponds roughly to the minimal number of tuples needed in the visited map for parallel processing to occur.

When AutoParallel is disabled, AutoParallelThreshold has no effect.

Changing This Parameter

To set the desired value for AutoParallelThreshold from the Terminal, use the SetOption(“AutoParallelThreshold”)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 AutoParallelThreshold 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).

Purpose of this instance: Draft documentation
DocReleaseID: IRISforHealth2025.1
Content loaded from:
/staging/learning/iris-doc/2025.1.x/doc/cache/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/ensemble/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/security/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/irishealth/en-us/src/
/staging/learning/iris-doc/2025.1.x/doc/healthcommon/en-us/src/
Excluded items: GCONV
FeedbackOpens in a new tab