[rt-users] Performance and responsetime in RT 3.0.10

Palle Girgensohn girgen at pingpong.net
Sun May 2 17:57:48 EDT 2004


--On söndag, maj 02, 2004 14.23.24 -0400 Jesse Vincent 
<jesse at bestpractical.com> wrote:

>> > 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.

Cool. Looking forward to the release :)

Palle






More information about the rt-users mailing list