Speeding Up RT by Removing Code to Display File Sizes

We’ve been battling RT speed issues on our server over the past couple
of months. We had one ticket that took almost three minutes to load
with 30 transactions on the ticket.

One of our engineers found that removing the code that calculates the
file size of attachments and transactions significantly sped up our RT
installation. I’ve included his email to me below for reference.

I thought this might be of interest to those of you looking for way to
get better performance out of RT.

-JasonBegin forwarded message:

I have made some more UI customization to RT to remove some of the
performance bottlenecks. Specifically, I changed the download links
generation code on both the ShowTransactions and ShowAttachments to not
caculate and subsequently display the size of each file. By doing this
I was able to reduce the time by half for display the history and
tickets. This did not seem to drastically reduce the available
information.

We’ve been battling RT speed issues on our server over the past couple
of months. We had one ticket that took almost three minutes to load
with 30 transactions on the ticket.

One of our engineers found that removing the code that calculates the
file size of attachments and transactions significantly sped up our RT
installation. I’ve included his email to me below for reference.

Jason,

What version of RT are you using? This is something we addressed

a couple revs of RT back in a somewhat less invasive way.

Best,
Jesse

We’re running 3.0.10.

-JasonOn Jun 22, 2004, at 5:13 PM, Jesse Vincent wrote:

On Tue, Jun 22, 2004 at 03:30:39PM -0700, Jason Grigsby wrote:

We’ve been battling RT speed issues on our server over the past couple
of months. We had one ticket that took almost three minutes to load
with 30 transactions on the ticket.

One of our engineers found that removing the code that calculates the
file size of attachments and transactions significantly sped up our RT
installation. I’ve included his email to me below for reference.

Jason,

What version of RT are you using? This is something we addressed
a couple revs of RT back in a somewhat less invasive way.

Best,
Jesse

We’re running 3.0.10.

That’s really surprising. Especially since those filesizes are
pre-generated and cached. I’d love to hear more information from your
engineer.> >On Tue, Jun 22, 2004 at 03:30:39PM -0700, Jason Grigsby wrote:

We’ve been battling RT speed issues on our server over the past couple
of months. We had one ticket that took almost three minutes to load
with 30 transactions on the ticket.

One of our engineers found that removing the code that calculates the
file size of attachments and transactions significantly sped up our RT
installation. I’ve included his email to me below for reference.