[rt-users] crazy sql during "reply" action

[Jesse Vincent]

On Mon, Apr 14, 2003 at 04:02:19PM +1000, Jamie Wilkinson wrote:
> This one time, at band camp, Jesse Vincent wrote:
> >That query is very much not what is generated by 0.81_02 on my box. I
> >think you have an older SB installed somewhere in your @INC before
> >0.81_02
> 
> The big hammer shows me:
> 
> /home/jaq/rt-3-0-0/lib/RT/SearchBuilder.pm
> /opt/rt3/lib/RT/SearchBuilder.pm
> /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm
> 
> the last of which contains the line
> 
> $VERSION = "0.81_02";
> 
> *pause as he goes to edit RT/SearchBuilder.pm to log the version*
> 
> Aha.  It turns out I hadn't reloaded the webserver and hence mod_perl hadn't
> reloaded the module.  Now the query takes about 6 seconds, which is much more
> tolerable.  Thanks for that.

Ah. Thank God. There are a few things I can do to get that down a good
deal further, but not before I head to Europe for a month on Tuesday.
I'm really glad to hear that we've beaten postgres into at least partial
submission.

	-j


> 
> -- 
> jaq at spacepants.org                           http://spacepants.org/jaq.gpg
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.