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

[Philip Kime]

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

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

--