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
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
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
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
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
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
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
>>
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
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