[rt-users] Performance with many attachments and transactions

[Kevin Murphy]

Hi all,

Just a sanity check:

I'm assuming it is not unreasonable for a ticket with 44 attachments and 
75 transactions to take 13-14 seconds to load?

RT 3.4.4 is running on Apache 1.3.33 with mod_perl compiled in, Perl 
5.8.6, database is PostgreSQL 8.0.4, DBIx::SearchBuilder  is 1.33, Mason 
is 1.3101.  Machine is Mac OS X 10.4.3 on dual 1.42 GHz PowerMac G4 with 
2GB RAM, idle at the time of my test.

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.

The ticket's html source is 113,683 bytes and is sent over a 100Mbit/sec 
LAN.  The time for my browser (Firefox) to receive and render a static 
version of the ticket page from the same web server is well under a 
second.  So query, transmission, and rendering time is <= 2 seconds, 
perl squirrelling is ~ 11-12 seconds.  Seems like a lot, somehow.

Thanks,
Kevin Murphy