Found the culprit - DBIx::Searchbuilder 1.46. I downgraded to 1.45_02 and it's now fine. I have attached the query log of trying to open the Query Builder page with 1.46. All that repeated
OR Principals_1.Disabled = '0' Looks a little odd ... PK -----Original Message----- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 5:21 PM To: Philip Kime Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgraded Perl and apache/mod_perl and now a few things are really slow ... On Thu, Mar 01, 2007 at 05:18:35PM -0800, Philip Kime wrote: > RT 3.6.3. > > I upgraded a server running apache/mod_perl to the latest stable > versions, re-compiling them on a 64-bit RHEL4 box. I used the worker > module for apache. I also re-compiled a 64-bit perl. Previously, the > box was using 32-bit everything. Anyway, with the new setup, it all > works except I get really slow repsonse times for loading the > query-builder and the Reply page for tickets - about 90 seconds each. > This makes me think it's related to the Owner drop-down. However, if I > stop apache, put back the original Perl and original apache, both of > those pages are fine and fast. So, it doesn't seem to be a DB problem? > > I did re-compile and install all the RT required perl modules from > scratch - perhaps a newer version of some module isn't working > properly > - anyone know of anything like this? Compare the output from the "RT variables and module listing" page from running RT with both perls? > > Any ideas? > > PK > > -- > Philip Kime > NOPS Systems Architect > 310 401 0407 > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com Commercial support: > [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com --
rtlog.txt.gz
Description: rtlog.txt.gz
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com