[Rt-devel] RT3 Speed - Tickets display

[Matthew Watson]

Heya.

 

 In the ever continuing effort to get RT3 up to acceptable speed, I'm
currently trying to speed up Ticket display page, particularly when
dealing with

Large tickets.

 

An example, I have a ticket which has slightly over 100 transactions on
it. This takes between 25-50 seconds to display, only a very small
fraction of that is in the database, from what I can see, most of the
time is spent checking the ACL, mostly getting cache hits, however there
seems to be ridiculous number of acl calls.

 

Below I have the output from dprofpp ( using DProf and standalone_httpd
). If I'm reading it correctly, there is over 30,000 calls to HasRight,
which seems excessive.

 

I suspect there isn't a lot that can be done as far as configuration to
improve this, but if anyone has any ideas, that would be great, or even
if this is something that has been improved in the beta releases?

 

 

Total Elapsed Time = 299.2237 Seconds

  User+System Time = 28.21374 Seconds

Exclusive Times

%Time ExclSec CumulS #Calls sec/call Csec/c  Name

 19.8   5.605 13.365 108659   0.0001 0.0001
DBIx::SearchBuilder::Record::Cacha

                                             ble::LoadByCols

 9.18   2.590 16.643 108659   0.0000 0.0002  RT::Record::LoadByCols

 6.39   1.803  5.342 109191   0.0000 0.0000
DBIx::SearchBuilder::Record::Cacha

                                             ble::new

 6.30   1.778  4.287 157646   0.0000 0.0000  RT::Record::__Value

 5.00   1.412 11.849  32356   0.0000 0.0004  RT::Principal::HasRight

 4.83   1.363  1.734 108659   0.0000 0.0000
DBIx::SearchBuilder::Record::Cacha

 
ble::_gen_alternate_RecordCache_ke

                                             y

 4.13   1.165  1.979 157646   0.0000 0.0000
DBIx::SearchBuilder::Record::Cacha

                                             ble::__Value

 3.98   1.124  3.067 108659   0.0000 0.0000
DBIx::SearchBuilder::Record::Cacha

                                             ble::_fetch

 3.73   1.051  1.051 218713   0.0000 0.0000  RT::Base::CurrentUser

 3.32   0.937  2.262 217521   0.0000 0.0000
Cache::Simple::TimedExpiry::fetch

 3.02   0.852  0.852 218452   0.0000 0.0000
Cache::Simple::TimedExpiry::expire

 2.98   0.842  3.277 109191   0.0000 0.0000
DBIx::SearchBuilder::Record::new

 2.91   0.821  0.821 218863   0.0000 0.0000
DBIx::SearchBuilder::Record::Table

 2.56   0.721  0.814 158292   0.0000 0.0000
DBIx::SearchBuilder::Record::__Val

                                             ue

 2.53   0.713  0.713 346771   0.0000 0.0000
DBIx::SearchBuilder::Record::id

 

 

 

Regards

 

--

Matthew Watson

Netspace Online Systems

(03) 98110010

 


This email and any files transmitted with it are confidential and intended solely for the 
use of the individual or entity to whom they are addressed. Please notify the sender 
immediately by email if you have received this email by mistake and delete this email 
from your system. Please note that any views or opinions presented in this email are solely
 those of the author and do not necessarily represent those of the organisation. 
Finally, the recipient should check this email and any attachments for the presence of 
viruses. The organisation accepts no liability for any damage caused by any virus 
transmitted by this email. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.bestpractical.com/pipermail/rt-devel/attachments/20041125/78e446f9/attachment.htm