For showing up bottleneck in your programm try to use a Benchmark::Timer: 
    use Benchmark::Timer;
    $t = Benchmark::Timer->new(skip => 1);
    
    foreach my $field (sort @$field_order) {
        $t->start('tag');
        print "\t<TR>\n";
        print "\t\t<TH ALIGN=RIGHT>$field :</TH>\n";
        for my $i (0 .. $num_recs) {
            print "\t\t<TD ALIGN=LEFT>$records->[$i]->{$field}</TD>\n"
+;

        }

        print "\t</TR>\n";
        $t->stop;
    }   

    $t->report;

[download]
and Devel::Profiler: 
$ perl -MDevel::Profiler your_script.pl

[download]
tnan see results 
$ dprofpp

[download]
If you run your script under mod_perl you can use Devel::Profiler::Apache: 
# in httpd.conf
 PerlModule Devel::Profiler::Apache;

 # or in startup.pl
 use Devel::Profiler::Apache;

[download]
Because it's very difficult to find out problem just to see a code,
but using of profiler and benchmark help you very well.
Good luck! 
      
--------------------------------
SV* sv_bless(SV* sv, HV* stash);

In reply to Re: Program slows dramatically! by nite_man
in thread Program slows dramatically! by shemp

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.