[rt-users] httpd speed on rt3

Fri Jan 23 12:35:43 EST 2004

In that case:

If youhave already made the change I suggested, replace the:
% while (my $Transaction = $Transactions->Next) {
% $Transaction = $Transactions->Last if
($m->request_comp()->title=~/Ticket\/Display\.html/);

With:

%my $firstprinted=0;
% while (my $Transaction = $Transactions->Next) {
% $Transaction = $Transactions->Last if
($m->request_comp()->title=~/Ticket\/Display\.html/ && $firstprinted==1);
% $firstprinted=1;

That will show you the first and last.

A.J.

-----Original Message-----
From: Scott Hebert [mailto:scott at cae.com] 
Sent: Friday, January 23, 2004 9:29 AM
To: 'AJ'; 'Rt-Users (E-mail)'
Subject: RE: [rt-users] httpd speed on rt3

AJ,

This has sped things up for me.

However, my users want to see this first transaction (typically the body of
an email sent in to create the ticket) and the last one.

What would be the fix for that?

Thanks,

SH

-----Original Message-----
From: AJ [mailto:rt at musefoundry.com]
Sent: Thursday, January 22, 2004 8:08 PM
To: 'AJ'; 'Rt-Users (E-mail)'
Subject: RE: [rt-users] httpd speed on rt3

Actually Mike reminded me that I should put a correction to what I put
before.

Only one line.

Right under the following line in the html/Ticket/ShowHistory component:
% while (my $Transaction = $Transactions->Next) {

Put:

% $Transaction = $Transactions->Last if
($m->request_comp()->title=~/Ticket\/Display\.html/);

Display will only show last transaction.  History and modify will show all.

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of AJ
Sent: Thursday, January 22, 2004 2:50 AM
To: 'Mike Husband'; 'Rt-Users (E-mail)'
Subject: RE: [rt-users] httpd speed on rt3

in Ticket/Elements/ShowHistory:

ABOVE:
% while (my $Transaction = $Transactions->Next) {

Put:

% if ($m->request_comp()->title=~/Ticket\/Display\.html/) {
% my $Transaction = $Transactions->Last;
<& ShowTransaction, Ticket => $Ticket, Transaction => $Transaction,
ShowHeaders => $ShowHeaders, Collapsed => $Collapsed, RowNum => $i,
ShowTitleBarCommands => $ShowTitleBarCommands, %ARGS &>
%}

Moves cursor to the last one and prints it. The hits the while loop but
since you are already at the end goes right over it.

What version of Solaris you run?  I originally had the front end of RT on a
fully loaded E250 with Solaris 9 and the db on an 8 processor E3500 with 4.5
gigs ram and it was still slow. I moved the front end to linux and it made a
big difference.  Also, there is one param that should be set on Solaris that
will take care of the possible Log::Dispatch errors and allow you to log to
syslog if you want.

A.J.

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Mike Husband
Sent: Wednesday, January 21, 2004 8:46 PM
To: Rt-Users (E-mail)
Subject: RE: [rt-users] httpd speed on rt3

I have a few timings which might throw some more light on this.

I'm running RT 3.0.7 over postgresql 7.4 on Solaris.

A ticket with 2 small comments takes about 5 seconds to retrieve,
but a ticket with 10 small comments (200 to 500 bytes) and 4 attachments
(50K each)
takes about 18 seconds to retrieve.

My profile of executions shows that there are 106 SELECT statements, most
of which take less than 5 ms.  There are 8 permissions checks which take
about 20 to 30 ms each.  This gives a total sql time of less than 1 second.

The break down of wall-clock execution time is roughly as follows:

Check permissions; get ticket, custom fields, transaction list - about 3
seconds
Get comments/attachments - 14 seconds.

So it seems fairly clearly that the killer here is the time to process
attachments.

Is it possible to display only the last comment by default, and display all
only
if the user asks for history?  Would this be an acceptable compromise?

Mike

> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of Jesse
> Vincent
> Sent: Thursday, 22 January 2004 3:26 AM
> To: Douglas E. Warner
> Cc: rt-users at lists.fsck.com
> Subject: Re: [rt-users] httpd speed on rt3
>
>
>
> >
> > After fresh restart:
> > displaying ticket: 10s
> > replaying queries: 1.5s
> >
> > Then (not restarted):
> > displaying ticket: 9s
> > replaying queries: 0.06s
>
> >
> > I'm not seeing the same queries over and over again like
> Palle was; there 227
> > queries for the page load, but there's 88 transactions
> (that includes
> > comments, correspondance, and actions).
>
> Ok. I think there's the thing that's taking the time. how long are the
> comments and correspondence? Are there attachments to the ticket?  I'm
> betting that you don't see such performance issues on shorter
> tickets.
>
> This is a known issue with long tickets with a lot of attachment
> content, especially "binary" attachments that aren't
> displayed inline. A
> customer asked us to quote a fix for them. We've sent them
> the quote and
> are just waiting for them to decide whether or not to go for it. (It
> involves a bunch of changes to RT's core.)  Ruslan sent a draft of a
> possible fix to rt-devel as well, which may work for you.
>
> 	Jesse
>
> >
> > - -Doug
> >
> > - --
> > Douglas E. Warner    <dwarner at ctinetworks.com>     Network Engineer
> > CTI/PAdotNET         http://ctinetworks.com        +1 717 975 9000
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.2.3 (GNU/Linux)
> >
> > iD8DBQFADrCVJV36su0A0xIRAsZjAJ9T4bcmFklLUi/tWCW+MuE5Ja5UWACg3jEw
> > P4Ti1N5piu5t7htri1lrRNk=
> > =3w72
> > -----END PGP SIGNATURE-----
> >
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.bestpractical.com
> > http://lists.bestpractical.com/mailman/listinfo/rt-users
> >
> > Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm
>

--
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.
_______________________________________________
rt-users mailing list
rt-users at lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

_______________________________________________
rt-users mailing list
rt-users at lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

_______________________________________________
rt-users mailing list
rt-users at lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

_______________________________________________
rt-users mailing list
rt-users at lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm