[rt-users] httpd speed on rt3
Mike Husband
m.husband at leadup.com.au
Mon Jan 26 20:19:44 EST 2004
Scott & AJ
Thanks for the question, and the response.
I was thinking of doing something like this, and possibly
displaying the last 2 transactions.
However, the question I have is:
- what if there is only one transaction?
Will displaying first and last display the same transaction twice?
Will displaying the last two get in trouble?
I haven't looked at the code in detail to figure this out yet,
but if it's easy for you to resolve, AJ, it will be appreciated.
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of AJ
> Sent: Saturday, 24 January 2004 3:36 AM
> To: 'Scott Hebert'; 'Rt-Users (E-mail)'
> Subject: RE: [rt-users] httpd speed on rt3
>
>
> 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
_______________________________________________
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
More information about the rt-users
mailing list