How to install rt improvement patches?

Hello Chris,

We are using RT 3.0.3 with Postgres 7.3.2 on RedHat 8 and seeing a HUGE performance hit. It can take minutes to bring up the “comment” or “reply” screen and simply logging in can take 20 seconds.

I have come across your post to the rt-devel list on June 25th about your modified perl modules (patches). I was wondering what the install procedure is …? Do I just copy them over the existing files? (after making backups of course) The files are

Groups_Local.pm
SelectOwner
Users_Local.pm

I like RT a lot, but as it is, we have 6 people using RT and its taking 2 or 3 minutes for click of the ticket. I don’t want to be told to get rid of RT, so I dearly hope there are some optimizations that can be made.

Also, have you come up with any more performance gains by modifying the queries or tuning postgres?

I am also CC:ing the rt-users list in case someone else has the same questions that I do.

Thanks again for your patches and your time,

Val

p.s. I thought I’d mention our complete RT configuration:

RT 3.0.3 (upgraded from RT 3.0.2)
–with-modperl1
postgresql-7.3.2
apache_1.3.27
RedHat 8
dual intel 900s
1gb memory

Hello Chris,
We are using RT 3.0.3 with Postgres 7.3.2 on RedHat 8 and seeing a
HUGE performance hit. It can take minutes to bring up the "comment"
or “reply” screen and simply logging in can take 20 seconds.

What you want is actually upgrading to the massively speeded up
3.0.4rc2, which includes Chris’ patch and other ones that makes RT ~1
order of magnitude faster for some people:

http://www.fsck.com/pub/rt/devel/rt-3-0-4RC2.tar.gz

Thanks,
/Autrijus/