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.From: Scott Hebert [mailto:scott@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
From: AJ [mailto:rt@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.
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@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.
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Jesse
Vincent
Sent: Thursday, 22 January 2004 3:26 AM
To: Douglas E. Warner
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] httpd speed on rt3After fresh restart:
displaying ticket: 10s
replaying queries: 1.5sThen (not restarted):
displaying ticket: 9s
replaying queries: 0.06sI’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@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@lists.bestpractical.com
The rt-users ArchivesHave you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm
Request Tracker — Best Practical Solutions – Trouble Ticketing. Free.
rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives
Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
rt-users mailing list
rt-users@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@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@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