[rt-users] performance question

[Roy El-Hames]

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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>