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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
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 [EMAIL PROTECTED] or call us at +1 617
812 0745.
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy
a copy at http://rtbook.bestpractical.com
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
