[rt-users] Tuning RT4

[Jeff Fearn]

On 07/26/2011 02:34 AM, Adam Thompson wrote:
> I can't speak for the dev team, but I have noticed a distinct trend:
>
> Apache+mod_perl is very slow with RT4.0.
> Lighttpd+FCGI is fast with RT4.0.
> Standalone PSGI is really fast with RT4.0 (but not very scalable unless
> you know what you're doing).
>
> I haven't tested Apache with anything other than mod_perl, so I don't know
> if it's Apache-specific or mod_perl-specific.
>
> Most of the speed problems I've seen posted here are with RHEL/CentOS/SL
> stock httpd&  mod_perl installs, so it's also possible the problem is
> OS-specific.
>
> (And yes, I have a ticket open to try to narrow this down; unfortunately I
> haven't had time to keep following up on it.)

Hi, just thought I'd point out my experience, we are currently testing 
upgrading RT 3.8.8 to RT 4.0.1.

RT 3.8.8: RHEL5 + Apache + mod_perl + MySQL.

RT 4.0.1: RHEL6 + Apache + mod_perl + MySQL.

~120K tickets, ~13K users, DB ~11GB.

RT 4 is faster than RT3 so far.

Probably the most notable change is setting:

Set($AutocompleteOwners, 1);

Compare the display time "Tickets->New Search"

With AutocompleteOwners: Time to display: 0.442697
Without AutocompleteOwners: Time to display: 17.274538

13K users is quite painful on that page!

Cheers, Jeff.