[rt-devel] extremely slow query in rt 3.0.10 due to ILIKE instead of =

[Jesse Vincent]

> I'll ask the postgresql developers about this. We'll see what they 
> say. I also found the lines in SearchBuilder that handle this. Changed 
> between 0.98_1 and 0.99... So, I can downgrade for now, I guess... 
> Still, do you really need to match ID:s case-insensitive?

It's how searchbuilder-based apps work on every other database 
platform. Changing that behavior or making it db-specific worries me, 
especially since a lot of the data is stuff that humans search on.

> /Palle
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20040330/eae483c4/PGP.pgp