UPDATE sessions query

Hi All,

We are running into a problem with one of our Queues which has around
~12,000 new and open tickets in it. When clicking on the Queue from the
’Queues I administer’ it finds 12,122 tickets (at the moment), which is
fine and that page comes up nice and speedy (as speedy as expected with
that many tickets found anyway). The problem comes up when clicking on
any of the tickets on that resulting page though. Average time to
display the page is around 15-20 seconds.

I enabled mysql logging so I could see what is going on when I click on
one of those tickets and it ends up resulting in about a 1MB “UPDATE
sessions SET a_session =” query being performed. Then each time you go
"Back" to the results page and click on another ticket, it has to update
that session again.

I understand the reason this is so large is because it’s storing the
information about those ~12k tickets so you can do your First, Last,
Previous and Next’s when you go into that ticket.

Does anyone have any suggestions for something I can do speed this up?
Or is there an easy way to place a hard limit of the number of results
stored in the session?

I would think file based sessions would speed this up, but unfortunately
that won’t work for us as we are running two RT servers in a round robin
setup, so the session would invalid depending on which server they ended
up on during each new page.

System info:

RT 3.6.4 (also tried 3.6.6RC2, but no improvement)
MySQL 5.0.22
Apache 2.2.3
DBIx::SearchBuilder 1.50

Thanks!

-Dan

Good luck. I’ve been trying to figure this out myself with little help.

Keep up with my goings on at http://theillien.blogspot.com

Dan Stilts wrote:

Figured I would try this one more time…anyone have any ideas on this?

Thanks,
Dan

Dan Stilts wrote:

Hmm… Do you show unlimited results of that search? 12k tickets on
one page? or it’s paged results with XX tickets in results and 12k in
total?On Jan 13, 2008 9:35 AM, Dan Stilts dstilts@gaiaonline.com wrote:

Figured I would try this one more time…anyone have any ideas on this?

Thanks,
Dan

Dan Stilts wrote:

Hi All,

We are running into a problem with one of our Queues which has around
~12,000 new and open tickets in it. When clicking on the Queue from the
‘Queues I administer’ it finds 12,122 tickets (at the moment), which is
fine and that page comes up nice and speedy (as speedy as expected with
that many tickets found anyway). The problem comes up when clicking on
any of the tickets on that resulting page though. Average time to
display the page is around 15-20 seconds.

I enabled mysql logging so I could see what is going on when I click on
one of those tickets and it ends up resulting in about a 1MB “UPDATE
sessions SET a_session =” query being performed. Then each time you go
“Back” to the results page and click on another ticket, it has to update
that session again.

I understand the reason this is so large is because it’s storing the
information about those ~12k tickets so you can do your First, Last,
Previous and Next’s when you go into that ticket.

Does anyone have any suggestions for something I can do speed this up?
Or is there an easy way to place a hard limit of the number of results
stored in the session?

I would think file based sessions would speed this up, but unfortunately
that won’t work for us as we are running two RT servers in a round robin
setup, so the session would invalid depending on which server they ended
up on during each new page.

System info:

RT 3.6.4 (also tried 3.6.6RC2, but no improvement)
MySQL 5.0.22
Apache 2.2.3
DBIx::SearchBuilder 1.50

Thanks!

-Dan


The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in
touch today. Email us at sales@bestpractical.com or call us at +1 617
812 0745.

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. Buy
a copy at http://rtbook.bestpractical.com


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

The page only contains 50 tickets, but the session contains every ticket
in the ‘Search’ that is built, which is ~12k.

Thanks,
Dan

Ruslan Zakirov wrote: