Cancel running queries
Introduction
Count currently supports query cancellation for the following database connections:
Cancel queries in a canvas
If your role allows you to edit a canvas, and the canvas contains one of the supported databases above, the option to cancel all pending canvas queries will be available in the query menu:
Cancel queries in a connection
If your role allows you to edit a database connection, you are able to cancel all queries running in all canvases for that connection from the button at the bottom of the connection settings:
As this action can cause errors in many canvases, it must be confirmed from the pop-up dialog:
How query cancellation works
The effectiveness of cancelling a query from Count may depend on the database connection used, and when the cancellation was requested.
The lifetime of a query proceeds as follows:
A query is submitted from a canvas and queued up to be executed - cancelling within this window will always succeed, though this time period is often short.
Count requests a slot from your database to execute the query - cancelling within this window will always succeed, and the duration of this period can vary depending on your database and the current load on it.
The query is submitted to your database - cancellation from Count is not always guaranteed for some database types, though the cancellation request is always sent to your database.
Last updated