<div class="gmail_quote">On 12 April 2011 02:53, will trillich <span dir="ltr"><<a href="mailto:will.trillich@serensoft.com">will.trillich@serensoft.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi folks -- this may be more of a FormHandler question than a Catalyst question but I thought I'd check here to see if it's just us:<div><br></div><div>We've been using HTML::FormHandler and are basically happy with it... until the performance issue mentioned below hit us. Any Catalystas running into 50-second turnaround time with H:FH?<br clear="all">
<br></div><div><div><font face="'courier new', monospace">[info] Request took 51.956100s (0.019/s)</font></div><div><font face="'courier new', monospace">.------------------------------------------------------------+-----------.</font></div>
<div><font face="'courier new', monospace">| Action | Time |</font></div><div><font face="'courier new', monospace">+------------------------------------------------------------+-----------+</font></div>
<div><font face="'courier new', monospace">| /auto | 0.000181s |</font></div><div><font face="'courier new', monospace">| /auth | 0.001857s |</font></div>
<div><font face="'courier new', monospace">| /ticket/base | 0.004652s |</font></div><div><font face="'courier new', monospace">| /ticket/item | 0.005865s |</font></div>
<div><font face="'courier new', monospace">| /ticket/edit | 51.88091s |</font></div><div><font face="'courier new', monospace">| Base:EDIT | 51.88050s |</font></div>
<div><font face="'courier new', monospace">| get FORM | 0.000078s </font><span style="font-family:'courier new', monospace">|</span></div>
<div><span style="font-family:'courier new', monospace;background-color:rgb(255, 255, 153)">| process FORM | <b>51.87286s</b> |</span></div>
<div><span style="font-family:'courier new', monospace">| /end | 0.000290s |</span></div><div><font face="'courier new', monospace">'------------------------------------------------------------+-----------'</font></div>
</div><div><br></div><div>Turnaround time ranges from 6 seconds to 50+ seconds, with no discernable pattern to the delay. (We can edit the same record multiple times and get wildly differing lags.)</div><div><br></div><div>
<br></div></blockquote><div>Run your test server with perl -d:NYTProf <a href="http://myapp.pl">myapp.pl</a> and see which routines use the time <a href="http://search.cpan.org/perldoc?Devel::NYTProf">http://search.cpan.org/perldoc?Devel::NYTProf</a> .</div>
<div>Maybe it is blocking on DNS network lookups.</div><div>Or if the time isused around the database calls, run with DBIC_TRACE=1 perl <a href="http://myapp.pl">myapp.pl</a> and watch and see which are the slow ones, then run your database query optimiser like EXPLAIN SELECT foo; <a href="http://dev.mysql.com/doc/refman/5.0/en/explain.html">http://dev.mysql.com/doc/refman/5.0/en/explain.html</a> <a href="http://www.postgresql.org/docs/8.3/static/sql-explain.html">http://www.postgresql.org/docs/8.3/static/sql-explain.html</a> </div>
<div>Are other processes/users accessing the same database? If so check for lock competition. Also disk space.</div><div><br></div><div>Regards, Peter</div><div><br></div><div> </div></div>