[rt-users] performance question

[Ruslan Zakirov]

Yep, this could help, however in this case we have to make step back
from generalized component /Elements/QueuesSummary we implemented in
3.6 branch.

On 12/1/06, Roy El-Hames <rfh at pipex.net> wrote:
> 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.
> >

-- 
Best regards, Ruslan.