Show TOC

Syntax documentation*NO_PARALLEL_QUERY Locate this document in the navigation structure

Allowed uses: By Commit, SQL

*NO_PARALLEL_QUERY

This instruction suppresses the generation of parallel queries on the server.

SQL server automatically tries to run multiple queries in parallel, if possible. In case many k2logic executions are requested to the server simultaneously, this mechanism may end up using too much memory on the server, ultimately slowing down the process, or even generating an "out of memory" error.