[rt-users] Speeding up RT3

Mon Oct 4 04:31:05 EDT 2004

Funny you should mention this.. I'm having exactly the same
Problems

DProf is giving me a lot of these errors

unstacked calls in outer
Garbled profile is missing some exit time stamps:

The only way I can get it to show results is with dprofpp -F

And this is what comes out

Total Elapsed Time = -4.27563 Seconds
  User+System Time =        0 Seconds
Exclusive Times
%Time ExclSec CumulS #Calls sec/call Csec/c  Name
 0.00   7.492 12.054     18   0.4162 0.6697
Locale::Maketext::Lexicon::Gettext
                                             ::parse
 0.00   3.903  4.564  34594   0.0001 0.0001
Locale::Maketext::Lexicon::Gettext
                                             ::transform
 0.00   0.589 13.217      2   0.2946 6.6083
Locale::Maketext::Lexicon::import
 0.00   0.540  0.486  29981   0.0000 0.0000  Encode::decode_utf8
 0.00   0.519  0.547     18   0.0288 0.0304
Locale::Maketext::Lexicon::lexicon
                                             _get_
 0.00   0.448  1.313     32   0.0140 0.0410
HTML::Mason::Commands::BEGIN
 0.00   0.207  0.292      1   0.2069 0.2924
Convert::ASN1::parser::yyparse
 0.00   0.189  0.891     12   0.0158 0.0743  RT::I18N::BEGIN
 0.00   0.179  0.651     18   0.0099 0.0361  RT::Tickets::BEGIN
 0.00   0.169  0.188     15   0.0113 0.0126  Convert::ASN1::BEGIN
 0.00   0.149  2.173     13   0.0115 0.1672  RT::Record::BEGIN
 0.00   0.148  0.166      6   0.0247 0.0276
DBIx::SearchBuilder::Handle::BEGIN
 0.00   0.139  1.594     14   0.0099 0.1138  RT::User::BEGIN
 0.00   0.129  3.839     13   0.0099 0.2953  RT::Mason::BEGIN
 0.00   0.129  0.719      9   0.0143 0.0799  Net::LDAP::BEGIN

Which doesn't look quite right, are these the same issues you are
getting?

Matthew Watson

> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-
> bounces at lists.bestpractical.com] On Behalf Of Jason A. Diegmueller
> Sent: Monday, 4 October 2004 2:46 PM
> To: rt-users at lists.fsck.com
> Subject: Re: [rt-users] Speeding up RT3
> 
> 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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com

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. 