[rt-users] RT 4 Upgrade Slow Performance

[Ruslan Zakirov]

Hi,

Probably next step would be Mason profiler. It's described in
RT_Config.pm. Once you know where WebUI is slow return back.

On Wed, May 30, 2012 at 12:32 AM, Nathan Baker <bakern at gmail.com> wrote:
> Hello Everyone,
>
> We've upgraded from RT 3.8.8 with MySQL to RT 4.0.5 (debian package) with
> Postgresql, and are having some performance issues with the web interface.
>  I've searched the list archives and Google, and haven't been able to find
> the issue.  I'm hoping someone can help point me in the right direction.
>  Basically, the first time I visit any page (Home, Display, etc.) it takes
> 3-5 seconds to load, and sometimes 10-15 seconds.  If I keep clicking on
> other links as soon as the pages load, it's fast and loads pages in 0.2 -
> 0.3 seconds.  If I wait for about 15-30 seconds and then click a link again,
> it takes 3-5 seconds to load again.  Updating tickets seems to consistently
> take 3-5 seconds.
>
> Here's some info about our installation:
> - About 6,000 tickets, 5 active users
> - Increased memory to 2GB, running on VMWare
> - Increased Postgresql shared_buffers and effective_cache_size
> (http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server)
> - Changed JS Minifier to jsmin as suggested
> here: http://www.gossamer-threads.com/lists/rt/users/102703
>
> Our config seems fairly basic compared so some examples I've seen, I can
> post it if necessary though.  We are using FullTextSearch and CommandByMail,
> although I've tried disabling them both.  I turned on debugging to a log
> file, and I don't see anything unusual.  I also turned on the SQL statement
> log, and didn't see any queries taking a long time.  The longest was 0.12
> seconds.  I tried disabling the Javascript Minifier in JS.pm like I've seen
> in other posts, and that didn't seem to make a difference.
>
> Any help would be greatly appreciated.
>
> Thanks,
> Nate



-- 
Best regards, Ruslan.