[rt-users] UPDATE sessions query

[Dan Stilts]

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:
> 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
>>
> 
> 
>