Re: [rt-users] performance question

2006-12-06 Thread Filip RembiaƂkowski
Ruslan Zakirov napisaƂ(a): > Could you spend some > time and write instructions about how to create such report? :) sure. 1) login to rt (probably ou want to login as root, to see all queues) 2) enable logging of all SQL queries. - for postgresql you can do it by putting these lines in your po

Re: [rt-users] performance question

2006-12-05 Thread 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 <[EMAIL PROTECTED]> wrote: Quick Search is the biggest culprit , typically 4 queries per queue .. so in your case (4 x 13

Re: [rt-users] performance question

2006-12-05 Thread Ruslan Zakirov
forgot patch On 12/6/06, Ruslan Zakirov <[EMAIL PROTECTED]> wrote: On 11/30/06, Filip Rembialkowski <[EMAIL PROTECTED]> 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

Re: [rt-users] performance question

2006-12-05 Thread Ruslan Zakirov
On 11/30/06, Filip Rembialkowski <[EMAIL PROTECTED]> 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

Re: [rt-users] performance question

2006-12-01 Thread 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 Gro

Re: [rt-users] performance question

2006-12-01 Thread Filip Rembialkowski
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

Re: [rt-users] performance question

2006-11-30 Thread Filip Rembialkowski
On Wed, November 29, 2006 17:17, Jesse Vincent wrote: > > On Nov 29, 2006, at 6:34 AM, Filip Rembialkowski wrote: > >> hi all RT users, >> >> at my work we have such setup: >> >> 135 queues >> 49000 tickets >> >> RT 3.4.1 running on >> Apache/1.3.33 (Debian GNU/Linux) mod_perl/1.29, Perl 5.8.4 >>

Re: [rt-users] performance question

2006-11-29 Thread Jesse Vincent
On Nov 29, 2006, at 6:34 AM, Filip Rembialkowski wrote: hi all RT users, at my work we have such setup: 135 queues 49000 tickets RT 3.4.1 running on Apache/1.3.33 (Debian GNU/Linux) mod_perl/1.29, Perl 5.8.4 I was running a test for following scenario: . Connect to web interface . Login as

[rt-users] performance question

2006-11-29 Thread Filip Rembialkowski
hi all RT users, at my work we have such setup: 135 queues 49000 tickets RT 3.4.1 running on Apache/1.3.33 (Debian GNU/Linux) mod_perl/1.29, Perl 5.8.4 I was running a test for following scenario: . Connect to web interface . Login as root . Display one random queue . Search for one random tick