Quick Search is the biggest culprit , typically 4 queries per queue ..
so in your case (4 x 135 = 540 queries) just for the little column on
the right ..
in 3.6.x you have the ability to only display the queues you are
interested in
It will be nice if the Quick search queries changed to use Group by ..
Roy
Filip Rembialkowski wrote:
On Thu, November 30, 2006 18:12, Jesse Vincent wrote:
I was talking about 3.4.1, because the results are very similar.
to be precise, I made this test again, just for a single home page view,
and have posted SQL log for single home page view here:
http://depesz.com/various/rt-3.6.1-homepage-view-sql-log.html
if you look at this, you will know what I mean
so the question is still valid.
is it needed to ask all these queries?
That sure looks to me like 21 real queries and 156 "DEALLOCATE" commands
that are (I presume) the result of reading whatever the queries return.
I don't think things are as bad as you thought they were.
i'd be happy if it was so good :)
first column is the query with placeholders, second column - number of
times it was executed
SELECT count(main.id) FROM Tickets main WHERE ((main.EffectiveId =
main.id)) AND ((main.Status != ?)) AND ((main.Type = ?)) AND ((main.Queue
= ?) AND (main.Status = ?)) -- 405 times
EXECUTE <unnamed> [PREPARE: SELECT * FROM Queues WHERE LOWER(Name) =
LOWER($1)] -- 135 times
and so on...
i'm just curious why does RT have to count tickets 405 times if there are
only 135 queues?
and why does it run "SELECT * FROM Queues" 135 times just do display the
homepage?
regards
F.
_______________________________________________
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
_______________________________________________
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
