[rt-users] RT 3.8.0 Search build page real slow

Ask Holme ask at jillion.dk
Tue Jul 29 06:23:26 EDT 2008

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 ?

More information about the rt-users mailing list