[rt-devel] Re: [rt-users] MIME support in rt1

Jesse Vincent jesse at bestpractical.com
Fri Oct 12 01:43:06 EDT 2001

Ok. a change in recent (Since august) DBIx::SearchBuilders caused RT to
_totally_ lose on indices with mysql. I just rolled 0.46-test1 in 

My quick benchmarking:

On a 150,000 ticket database (Yes, that's one hundred and fifty thousand 

Before the new DBIx::SearchBuilder, any nontrivial search of tickets took over
a minute and display of a single ticket took 15 seconds.

Now, the same search takes between 1 and 30 seconds (full text searches still
suck) and display of a single ticket takes 1 second.   I suspect that the "right" fix for postgres is to convert the indices to indices on lower(colname).

http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.

More information about the Rt-devel mailing list