[rt-users] Performance issues when viewing tickets with attachments

[Michael Gibbons]

Hi Jesse,

It sounds like this issue is a known issue but that it may require some 
work to resolve. However, given that it probably affects a *very* large 
chunk of RT's user base (those who use attachments) and that the issue 
is not a "minor" one (1 second vs 6 seconds on an average size ticket), 
I'm not sure I understand why fixing this isn't scheduled for the near 
to immediate future. It seems to me that this is exactly the kind of 
issue that you would want resolved (affects large number of users + 
serious performance problems).

Can you shed some more light on when exactly this might be scheduled? 
I'm sorry for my impatience, but I just spent about 30 seconds waiting 
for a single ticket to load (and our machines are by no means slow).

Thanks,
Mike

Jesse Vincent wrote:

>
>On Wed, Dec 03, 2003 at 01:02:44PM -0800, Mike White wrote:
>  
>
>>Hi all,
>>
>>We've noticed that the time it takes to display a ticket after clicking 
>>on it is significantly greater when that ticket has one or more 
>>attachments in one item of correspondence.  (ie, 1 second vs. 6 seconds.)
>>
>>Why would it need to grind away just to display a ticket?  Is there a 
>>solution for this? 
>>    
>>
>
>It's an issue that we're already aware of. Fixing it requires
>some fairly deep work that isn't currently scheduled for any time soon.
>
>The short version is that the database abstraction layer fetches whole
>rows from the attachments table (rather than lazy-loading the Content
>column) when listing off transaction attachments. I think we know how
>to fix it, when we do, but it's probably two or three days work that
>involves both RT and DBIx::SearchBuilder
>
>	-jesse
>
>  
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20031217/fd9461ba/attachment.htm>