[rt-users] performance question

[Ruslan Zakirov]

On 11/30/06, Filip Rembialkowski <filip.rembialkowski at eo.pl> wrote:

[snip]

> >
> > That sounds surprisingly high. But you're also testing with
> > an...older RT. And I know we've made some big performance
> > improvements since then. I can't guarantee that we've fixed whatever
> > you're running into, but coming up to 3.4.6 or 3.6 is strongly
> > recommended.
> >
> >
> actually i discovered this while evaluating RT 3.6.1 :)
> 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
Thanks for great report and good representation. Could you spend some
time and write instructions about how to create such report? :)

>
> so the question is still valid.
> is it needed to ask all these queries?
> can we optimize it somehow?
yep, at least get rid of the second line in your log. try attached
patch. don't forget to purge mason cache.

>
> greets,
> Filip
>
>

-- 
Best regards, Ruslan.