Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

background_priority option [deprecated]

Limits impact on the performance of connections other than the current connection.

Allowed values

On, Off

Default

Off

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No
Remarks

When this option is set to On, requests execute at the Background priority level. When this option is set to Off, requests execute at the value specified by the Priority option.

Intra-query parallelism is not used for connections with background_priority set to On.