[rt-users] Predefined Searches Question

Ham MI-ID, Torsten Brumm torsten.brumm at Kuehne-Nagel.com
Fri Nov 21 03:11:08 EST 2008


Hi RT Users, Developers,

today i discovered together with some users some strange issues with predefined searches, exactly the Unowned Tickets. Users with this search active (most of our users!) reported massiv performance problems.

Test Scenario: User has access to 3 Queues (modify Ticket rights) and not more. Inside the system are round about 1000 Queues with millions of tickets. Inside this 3 Queues of the user, there are only 4 Tickets which are new and unowned. The Query of this takes around 10 sec.

The Query behind Unowned Tickets: Owner = 'Nobody' AND ( Status = 'new' OR Status = 'open')

After changing this query to:

( Queue = 'QueueA' OR Queue = 'QueueB' OR Queue = 'QueueC' OR ) AND ( Status = 'new' OR Status = 'open') AND Owner = 'Nobody'

This query was done in 0.5 sec, which is much faster i think....

Any ideas how to fix this?

Torsten



More information about the rt-users mailing list