Page Comparison

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.

...

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

...

Rw ui steps macro

Rw step Go to Administration → Roles and select an existing role on the left tab (alternatively, you can create a New Role). Rw step Add the Query priority permission to the role to enable the query priority selector in the navigation bar (if you are creating a new role, select also the other permissions and resources you want for this role). Rw step Choose the Default query priority and Maximum query priority available for the role in the dropdown selectors that appear at the bottom. 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 Urgent. Image RemovedImage Added Rw step Click Apply Changes (or Create if you are creating a new role instead of modifying an existing one). The users with this role assigned will now be able to choose a different priority level for their session among the specified ones for their role (if you are creating a new role, don't forget to assign it to the desired users). Info 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).

...

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.

...