[rt-users] RT 4 Upgrade Slow Performance

[Nathan Baker]

Ruslan,

Thank you, that provided some great info.  I'm wondering if my issue (or
one of them) is from our custom fields.  There is one spot where it
consistently takes a couple seconds:

=Mason= localhost -
/Ticket/Elements/ShowCustomFields {{{
=Mason= localhost -
/Elements/ShowCustomFields {{{
=Mason= localhost -
/Elements/ShowCustomFields }}} 2.0221
=Mason= localhost -
/Ticket/Elements/ShowCustomFields }}} 2.0261
...
=Mason= localhost -     /autohandler }}} 3.2073

We only have 1 or 2 custom fields (depending on the Queue), and there are
less than 20 options for each.  Any ideas what could cause that, or is that
normal for custom fields?

Thanks,
Nate

On Tue, May 29, 2012 at 4:59 PM, Ruslan Zakirov <ruz at bestpractical.com>wrote:

> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120529/b1e525fa/attachment.htm>