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
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 ?