Query priority

Overview

Not all queries are of equal importance, and often assigning a higher priority to heavy queries might be required in order to prioritize them. The query priority determines the amount of resources allocated to a query. These are the available query priority levels in Devo (listed from lowest to highest):

• Minimum

• Normal

• Maximum

• Urgent

By default, queries run with their priority set to Normal, but Admin users can set a different default priority for a role, and define the range of priority levels they can access. Once defined, all users with this role can choose from the available range by clicking the drop-down tab at the top of the navigation bar. This allows them to smoothly switch between their available priority levels in their session. Learn more in the following sections.

What permissions do I need?

The query priority menu will not appear in the navigation pane unless the you have the Query priority permission (know more about permissions here).

Set the query priority range and the default priority for a role

The range of query priority levels that users can access is decided in the role management area, as well as the default value. Learn more about role creation and management in Managing roles.

Choose the required priority level in your session

If your role is allowed to select the query priority level, you will see a selector under your user name, in the navigation bar. Simply open it and choose the required level for your user session. For example, if your default priority level is Normal and you are working with a query that deals with a huge amount of data, you may want to prioritize it switching to Maximum or Urgent level.

Note that the query priority always reverts back to the default level with every new session.