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
>
--
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com