[rt-devel] Re: [rt-users] MIME support in rt1
rotman at inode.at
Fri Mar 26 11:13:03 EST 1999
> 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
with the new DBIx::SearchBuilders rt2 is A LOT faster but rt1 is
approx. the doubble as fast in displaying all open tickets
is there a chance that rt2 will catch up with this in future?
> 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.
Inode Telekommunikationsdienstleistungs GmbH - http://www.inode.at/
Tel.: 059999 2060 Fax.: 059999 2020
office at inode.at
More information about the Rt-devel