Hey List Lately (both before and after upgrade to 3.8.0) i'v been having problems with performance of the query builder. Overall RT runs quite fast, viewing of queues and tickets is fully acceptable and ticket updates is also fine. However, if i want to do a custom search and therefore opens a new query performance falls. The query builder page takes way over 1 minute to load and the same loading time apply for every term adding action. If build a moderately complex query i can easily use 20 minutes, just to add the terms - most of this waiting time. Looking on the server i can see, that RT eats about 70-80 pct. af my 2,8 gHZ Xeon CPU while sending the page to me.
The database is quite huge (about 1 GB holding 34k tickets with 300k transactions), however when both queue and ticket viewing is fast that can't be the problem ? Does anyone else of the have big trouble with the query building page ? Any ideas for how to speed it up ? _______________________________________________ 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