[rt-users] RT3 tuning - web interface seems slow

[Jesse Vincent]

On Tue, Apr 07, 2009 at 11:50:25AM -0700, Andrew Daviel wrote:
> On Tue, 7 Apr 2009, Jesse Vincent wrote:
> 
> >
> >
> >Andrew,
> >
> >Could you post the System Information from inside Configuration -> Tools
> >for your RT instance?
> 
> See http://andrew2.triumf.ca/helpdesk.config2.notes
> 
> (some minor sanitization)

I'd expect to see Apache::DBI.  That's a small bit of a perf hit right
there.

> 
> This is running on Scientific Linux 5.2.
> (Basically RedHat Enterprise recompiled from public source, like CENTOS)
> 
> We had upgraded at one point from I believe 3.0 to 3.8 using the upgrade 
> scripts.

You'll want to carefully doublecheck database indexes.  Also, have your
DBAs been maintaining the RT database? Have statistics been recomputed
lately?


> -- 
> Andrew Daviel, TRIUMF, Canada
> Tel. +1 (604) 222-7376  (Pacific Time)
> Network Security Manager
> 

--