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

[Robert Rotman]

> 
> 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 
> ftp://ftp.fsck.com/pub/rt/devel  
> 
> My quick benchmarking:
> 
> On a 150,000 ticket database (Yes, that's one hundred and fifty thousand 
> 				tickets)
>

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?


Robert

> 
> 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/
Robert Rotman 
Tel.: 059999 2060 Fax.: 059999 2020
office at inode.at