[rt-users] Predefined Searches Question

[Ham MI-ID, Torsten Brumm]

Hi Together,
found a good solution for this problem (file attached)

placed the file UnownedNew under /RT_HOME/local/html/Elements and added to RT_SiteConfig.pm at Homepage Components.

This file loads the Unowned Ticket much,much more faster.

Torsten


Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.),  Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne


-----Ursprüngliche Nachricht-----
Von: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von Ham MI-ID, Torsten Brumm
Gesendet: Freitag, 21. November 2008 09:11
An: RT Users
Betreff: [rt-users] Predefined Searches Question

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: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

-------------- next part --------------
A non-text attachment was scrubbed...
Name: UnownedNew.zip
Type: application/x-zip-compressed
Size: 989 bytes
Desc: UnownedNew.zip
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081121/e6cc16c2/attachment.bin>