Query priority
Note that this feature is only enabled in certain domains by default. If you need to use it and is not enabled in your domain, contact the Devo support team.
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.
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 creation, as well as the default value. Learn more about role creation in Managing roles.
- Go to Administration → Roles and select New Role.
- Select the required permission and resources you want to assign to the role. You must add the Query priority permission to the role to enable the query priority selector in the navigation bar.
- Choose the Default query priority and Maximum query priority available for the role in the dropdown selectors that appear at the bottom of the page. Note that the default value can only be set at Minimum or Normal. In the following capture, we are setting the default value for the role to Normal, and the maximum level they can select will be Maximum.
- Click Create. Users will now be able to choose a different priority level for their session among the available ones for their role.
Which is the priority level of the Admin and No Privileges roles?
The default query priority of the Admin role is Normal, and its maximum priority available is Urgent. However, you can modify these values as required by editing the Admin role.
The No Privileges role has not the Query priority permission, which means users with this role cannot switch to a different level and always work with the default one in Devo (Normal).
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.
Maximum and Urgent priority levels
If a user changes the priority level to Maximum or Urgent, a warning is triggered advising that this could slow down other queries in the domain. Running queries with these priority levels has a great impact, so you should go back to Normal or Minimum priority as soon as possible.
