[rt-users] Performance with many attachments and transactions

[Jesse Vincent]

On Thu, Nov 17, 2005 at 04:05:50PM -0500, Vivek Khera wrote:
> 
> On Nov 17, 2005, at 12:07 PM, Kevin Murphy wrote:
> 
> >There are 433 separate database queries made in the course of  
> >loading this ticket, whose cumulative time (as measured in the  
> >postgresql log file) is just 1.19 seconds, but the entire load  
> >takes 13-14 seconds, both according to the RT footer and by  
> >measuring the elapsed time across all database queries in the  
> >postgresql log file.
> 
> Did you also measure the time to transfer the bits from the Pg server  
> to the web server?  That may also be a bottleneck.  I can literally  
> see the delay in painting the page when RT encounters a large  
> attachment only to report a link with the size of the attachment.

Uh. It shouldn't be doing that with a modern version of RT. (If it is,
we're missing a ->columns() somewhere.

> It seems to me RT is fetching the whole large attachment just to find  
> its size and content type rather than just fetching the size from the  
> DB.  I could be wrong, though.
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Download a free sample chapter of RT Essentials from O'Reilly Media at 
> http://rtbook.bestpractical.com
> 
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at 
> http://bestpractical.com/services/training.html
> 

--