[rt-users] UPDATE sessions query

[Ruslan Zakirov]

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 at 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
> > _______________________________________________
> > 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 sales at bestpractical.com or call us at +1 617
> > 812 0745.
> >
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: sales at bestpractical.com
> >
> >
> > 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: sales at 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.