For some reason, my website has gotten progressively slower over the last few months. I don't think I've changed anything to yield these results.

Here's what I know - the scripts run lightning fast hosted on my local machine. Now, while I love my powerbook dearly, it is, admittedly, not exactly state of the art. Yes, yes, I know that I'm the only one hitting the webserver and I don't need to worry about network latency. I was sure to bring down a fresh database from the live site to be sure to compare identical data. Still. I ran it through Devel::DProf, and got this:

Total Elapsed Time = 2.282964 Seconds User+System Time = 1.392964 Seconds

Not too shabby. I can live with that. So then I ran the same thing through Devel::DProf on the hosted site:

Total Elapsed Time = 18.89348 Seconds User+System Time = 0.793482 Seconds

Eek. Behold the disastrous slowdown. And now I'm stumped. If my User+System Time were high, then no sweat - slog through the code, find slow things, optimize 'em away. Fun stuff. But this? This is external, and out of my control. Right?

So basically, I'm ruling out network problems, database issues, and generally anything in my script and seem to be at a point of blaming my host. FWIW, it's 1&1. So their hardware should be absolutely massive. But what could this be indicative of? Some sort of throttling? Restrictions? Essentially, before I begrudgingly begin the long, annoying path of switching hosts, I want to know if there's something - anything else I could/should be looking at to spare me the pain.


In reply to My CGI is slow, but I don't think it's my fault. by jimt

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.