[rt-users] Speeding up RT3

[Matthew Watson]

> -----Original Message-----
> From: Jesse Vincent [mailto:jesse at bestpractical.com]
> Sent: Friday, October 01, 2004 10:57 PM
> To: Matthew Watson
> Cc: rt-users at lists.fsck.com
> Subject: Re: [rt-users] Speeding up RT3
> 
> 
> 
> >  I'm currently in the process of performance testing RT3 and trying
to
> > speed things up where needed. Currently I'm finding that the front
page
> > is taking about 10 seconds to load for a non SuperUser (about 2-3
> > seconds for SU's).
> 
> What DBIx::SearchBuilder are you running?  

1.01

> How many queues do
> non-superusers have on the front page?

18 queues, which have the right "SeeQueue","CreatTicket" and
"ReplyToTicket" assigned to "Everyone".


 
> >
> > Tracking this down, it's the QuickSearch box that is the major
slowdown,
> > taking about 6 seconds to load, seeming most of that time is taken
up
> > processing the ACL in perl.
> >
> 
> Is that a guess or do you have profiling results?

Profiling using MasonX::Profiler.

> If you don't have profiling results, I'd strongly recommend you use
> standalone_httpd and Devel::DProf to profile and post those results.

I'll have a look into doing that.

 
> Also, what sorts of CPUs are sitting behind that oracle database? Have
> your DBAs spent time profiling what RT's doing on the database side
and
> looking for index improvements?

I'm not what the CPUs are off hand, it's dual processor sun hardware
with 4gb of ram, but I can't remember exactly what, however we have done
quite a bit of work making sure the database isn't the cause of the
problems, all the queries for the front page take less than 1 second to
run (combined).

The web front end is a 3ghz p4 with a gig of ram. Also tried running the
Web interface on an E450, but that was even slower.

Regards,
Matt.

 
> >
> >
> > My setup is.
> >
> >
> >
> >  RT 3.2.2
> >
> >  Oracle 9.2.0.5
> >
> >  About a million tickets
> >
> >  Apache 1.3.27/FastCGI
> >
> >
> >
> >
> >
> >
> >
> > Regards
> >
> >
> >
> > --
> >
> > Matthew Watson
> >
> > Netspace Online Systems
> >
> >
> >
> 
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Be sure to check out the RT wiki at http://wiki.bestpractical.com
> 
> --

This email and any files transmitted with it are confidential and intended solely for the 
use of the individual or entity to whom they are addressed. Please notify the sender 
immediately by email if you have received this email by mistake and delete this email 
from your system. Please note that any views or opinions presented in this email are solely
 those of the author and do not necessarily represent those of the organisation. 
Finally, the recipient should check this email and any attachments for the presence of 
viruses. The organisation accepts no liability for any damage caused by any virus 
transmitted by this email.