[rt-users] Speeding up RT3

[Jason A. Diegmueller]

All this talk about profiling and indexeing has me playing again tonight. 
A forewarning, I am not a coder, and I don't do perl.

I'm trying desparately to use DProf to figure out where all my time is 
being burnt up when loading larger tickets -- database?  Webserver? 
Something else?  However, I keep getting strange dprofpp errors 
and numbers that don't make sense (ttoal time in the negatives).

This is a relatively clean perl 5.8.5 install (upgraded just yesterday).

Am I missing a module?  Am I doing something wrong?

This appears to work on anything but standalone_httpd & webmux.pl.  If I 
run dprofpp -p rt, I get realistic figures (although, of course, it 
doesn't actually product any valuable output) which makes me think there 
is something specific and/or tricky about standalone_http.

I'm currently running RT 3.2.2.

Thanks!

--

[evelocity03:jdiegmueller] [/usr/local/rt/bin] # dprofpp -p 
standalone_httpd
You can connect to your RT server at http://localhost:8080/

<display a ticket>

[evelocity03:jdiegmueller] [/usr/local/rt/bin] # dprofpp
Exporter::Heavy::heavy_export
Garbled profile, unexpected exit time stamp at /usr/local/bin/dprofpp line 
666, <fh> line 755.

Faking 12 exit timestamp(s).
Total Elapsed Time = -8.35145 Seconds
   User+System Time =        0 Seconds
Exclusive Times
%Time ExclSec CumulS #Calls sec/call Csec/c  Name
  0.00   1.030  1.810  74161   0.0000 0.0000  RT::Record::__Value
  0.00   0.918  4.497  14592   0.0001 0.0003  RT::Principal::HasRight
  0.00   0.899  2.198  48964   0.0000 0.0000 
DBIx::SearchBuilder::Record::Cacha
                                              ble::new
  0.00   0.859  4.387  49090   0.0000 0.0001  RT::Record::LoadByCols
  0.00   0.790  0.719  49090   0.0000 0.0000 
DBIx::SearchBuilder::Record::Cacha

ble::_gen_alternate_RecordCache_ke
                                              y
  0.00   0.750  0.516 155929   0.0000 0.0000 
DBIx::SearchBuilder::Record::id
  0.00   0.720  3.709  49090   0.0000 0.0001 
DBIx::SearchBuilder::Record::Cacha
                                              ble::LoadByCols
  0.00   0.710  0.857  99034   0.0000 0.0000 
Cache::Simple::TimedExpiry::fetch
  0.00   0.700  0.885  74161   0.0000 0.0000 
DBIx::SearchBuilder::Record::Cacha
                                              ble::__Value
  0.00   0.630  1.397  49090   0.0000 0.0000 
DBIx::SearchBuilder::Record::Cacha

ble::_lookup_primary_RecordCache_k
                                              ey
  0.00   0.590  1.103  49090   0.0000 0.0000 
DBIx::SearchBuilder::Record::Cacha
                                              ble::_fetch
  0.00   0.550  1.319  48964   0.0000 0.0000 
DBIx::SearchBuilder::Record::new
  0.00   0.540  0.390  99870   0.0000 0.0000 
Cache::Simple::TimedExpiry::expire
  0.00   0.530  0.383  98278   0.0000 0.0000  RT::Base::CurrentUser
  0.00   0.520  0.407  74812   0.0000 0.0000 
DBIx::SearchBuilder::Record::__Val
                                              ue