RT 3.0.11 with PostGreSQL

If you run RT 3.0.11 on Debian Stable (or any other OS with an old DBIx::SearchBuilder) RT will act very very slowly when you reach about 2000+ tickets.

This problem is caused by using ILIKE's instead of = for matching integers. I urge everyone to upgrade to DBIx::SearchBuilder 1.01 (current in CPAN) to fix this issue. Response times are now down to around 1 second instead of 30+ seconds, this is ofcourse thanks to the indexes that are now used.

Upgrading DBIx::SearchBuilder to version 1.01 does not improve performance for MySQL (which you actually should not use at all ;)


Name:  
Remember personal info?

Email:
URL:
Comment:Emoticons / Textile

  ( Register your username / Log in )

Notify: Yes, send me email when someone replies.  

Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.