User bio
Senior Software Engineer with over a decade of experience working with InterSystems Products.
Member since Apr 27, 2017
Posts:
Replies:
AutoParallel and Adaptive Mode are enabled by default in InterSystems IRIS SQL query optimizer. Because of this, IRIS will automatically determine when parallel query execution is beneficial. Therefore, you usually don’t need to manually specify %PARALLEL unless you want to force parallelism or override the optimizer’s decision.
- When AdaptiveMode is enabled, automatic parallel processing is applied to all SELECT queries, hinting them with %PARALLEL. However, not all queries may use parallel processing as the SQL Optimizer may decide otherwise.
- When we are trying to utilize this %PARALLEL feature, we must consider AutoParallelThreshold as well (default value is 3200) and there is no use with this parameter in case AutoParallel is disabled.
Hi @Anastasia Dyubaylo
How do I submit an application for this contest? Is there a specific option I need to select when submitting the application?
Open Exchange applications:
Certifications & Credly badges:


Global Masters badges:







Followers:
Following:
You can determine whether the value is an object by using $IsObject(value) before processing it.
Alternatively, you can rely on the third argument of %GetNext(,,.type), which tells you the datatype of the value.
Example code
set iter = identifiers.%GetIterator() while iter.%GetNext(.key, .value, .type) { if $IsObject(value) { set text = value.%Get("text") } }set iter = identifiers.%GetIterator() while iter.%GetNext(.key, .value, .type) { if type = "object" { set text = value.%Get(key) ;for example value.%Get("text") } if type = "array" { set text = value.%Get(index) ; for example: value.%Get(0) } }