On Tue, 7 Apr 2009, Jesse Vincent wrote: > I'd expect to see Apache::DBI. That's a small bit of a perf hit right > there.
rt-test-dependencies says that it's present, as does the cpan CLI if asked to install "Apache::DBI". I see Apache::Session::Store::DBI v1.02; in the config $ rt-test-dependencies -v DBI >= 1.37...found > You'll want to carefully doublecheck database indexes. Also, have your > DBAs been maintaining the RT database? Have statistics been recomputed > lately? I believe all install and upgrade recipes were followed properly. Though we currently have a (presumably) unrelated problem with image attachments getting corrupted (change to UTF-8 ??). We have a relatively small staff with no fulltime DBA. I am not sure what maintenance is recommended; I recently ran "optimize table sessions" recommended by the tuner which made no difference. I do not believe any statistics were computed; where is this documented ? I found RT3BatchStats in the wiki which fails halfway with "Unknown column 'Transactions.Ticket'" Per my original post, raw database queries seem to run quite fast. Unless I am missing some complex query which the Web interface is making. regards -- 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