[rt-devel] performance problems

[Andrew Stribblehill]

Quoting Jesse Vincent <jesse at bestpractical.com> (2004-01-19 13:06:25 GMT):
> 
> > > And yes, quite frankly, your report isn't very useful. ;-)  Still, 
> > > interesting to hear that the problem just disappeared? Did you modify your 
> > > data in anyway.
> > 
> > Not at all. I certainly didn't change the schema at all, but all I
> > was doing was viewing a ticket. A rather long ticket, admittedly, but
> > nothing that should cause 1366 of the following queries:
> > 
> > 	SELECT * FROM Principals WHERE PrincipalType ILIKE  'User' AND
> > 	ObjectId =  '24'
> 
> That looks just like the bug we fixed in searchbuilder 0.96. Hm.

I *know* I was using SBr 0.96 since I'd just packaged it for Debian
and moreover, I was wondering if performance would be improved by
changing the ILIKE thing back into a plain '='. The answer was no,
but that's not the point right now :)

-- 
NORTHWEST FITZROY
VARIABLE 3 OR 4 BECOMING SOUTHERLY 4 OR 5, OCCASIONALLY 6 LATER IN
FAR WEST. FAIR. MAINLY GOOD