MIME support in rt1

RT Developers
1

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)

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.

2

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@inode.at

3

Hello,

After some tests with rt2 im forced to go on with rt1 for
performance reasons:(((

So my question:
Is there any possiblillity display the subject line correctly
for foreign charakters in rt1?

Robert

4

Hello,

After some tests with rt2 im forced to go on with rt1 for
performance reasons:(((

So my question:
Is there any possiblillity display the subject line correctly
for foreign charakters in rt1?

Speaking of which, there is trouble inserting czech characters in RT2,
basically because it is all ISO-8859-1 I believe. Is there any chance of
going for UTF-8?

patrik_wallstrom->foodfight->pawal@blipp.com->+46-706355528