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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
