[rt-devel] performance problems
a.d.stribblehill at durham.ac.uk
Mon Jan 19 08:16:05 EST 2004
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 :)
VARIABLE 3 OR 4 BECOMING SOUTHERLY 4 OR 5, OCCASIONALLY 6 LATER IN
FAR WEST. FAIR. MAINLY GOOD
More information about the Rt-devel