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
PK
Philip Kime
NOPS Systems Architect
310 401 0407
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.
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 …
PKFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
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
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
The rt-users Archives
Community help: http://wiki.bestpractical.com Commercial support:
sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
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)
PGP.sig (186 Bytes)