[rt-users] Performance and responsetime in RT 3.0.10

[Jesse Vincent]

> >Main point is that there is a bug where it wants to use ILIKE for 
> >primary key and ID:s, and this is not very clever. Jesse admitted that 
> >this was wrong, but I have no idea how to fix it. It bumps queries from 
> >10 ms to 30 ms, it is not really a big deal.
> This should be fixed in DBIx::SB, but it's not so easy. DBIx::SB doesn't 
> know anything about field types so can't make decision where use 
> ILIKE/LOWER and where not to make query case insensetive. Pg doesn't 
> optimize ILIKE or LOWER too if field is numeric.

FWIW, I believe that RT does much better with not trying to "lower" id
or other numeric columns in 3.1. It's not perfect yet, but it's better.
--