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:[EMAIL PROTECTED] Sent: Wednesday, March 07, 2007 11:35 AM To: Philip Kime Cc: rt-users@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: > [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