[rt-users] Longgggg ticket taking a while to load

Jesse Vincent jesse at bestpractical.com
Wed Mar 7 14:48:16 EST 2007


On Mar 7, 2007, at 2:43 PM, Philip Kime wrote:

> Well, it's not a huge problem - I suspect we'll concentrate on  
> getting a
> version of DBIx::SearchBuilder to work with memcahced first ... If you
> have an example of doing this with Jifty::DBI ( I think you did?), it
> would be helpful to look at it. I looked at the latest version of this
> on CPAN but didn't see any memcached API calls in there ...
>

It's an alternate backend for Jifty::DBI::Record (memcache instead of  
cache::simple::timedexpiry)

> PK
>
> -----Original Message-----
> From: Jesse Vincent [mailto:jesse at bestpractical.com]
> Sent: Wednesday, March 07, 2007 11:35 AM
> To: Philip Kime
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Longgggg ticket taking a while to load
>
>
>
>
> On Thu, Mar 01, 2007 at 11:51:18PM -0800, Philip Kime wrote:
>> We have one particular ticket at the moment which has about 175
>> transactions in it - lots of replies/comments etc. No binary  
>> stuff, no
>
>> attachments, just text and not that much text per transaction. But it
>> takes nearly two minutes to load up. After loading, something is
>> cached, either query and/or MASON stuff and it takes about 15 seconds
>> to load until it gets cleared out of the cache. I wonder if there  
>> is a
>
>> DB index we might add for this? Anybobody else had this? RT 3.6.3
>
> I have a sneaking suspicion that the issue is Text::Quoted's parsing.
> But I'm not 100% sure.
>>
>> PK
>>
>> --
>> Philip Kime
>> NOPS Systems Architect
>> 310 401 0407
>>
>
>> _______________________________________________
>> 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
>
> -- 
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070307/18e7231f/attachment.sig>


More information about the rt-users mailing list