-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Rusty Keele was heard saying on 03/01/2008 09:31 AM: | Hey, | | Here are some ideas: | | - Statistics scripts like Stat Counter can load slowly if their site is having problems or under heavy load | | - Poorly written database queries can really drag performance down. Is there anywhere you could use one query instead of multiple calls to the db? | | - You could install the Firebug add-on (if you're using Firefox) - it has a tool that allows you to time how long each element on the page is taking to load. That could be useful in finding the problem. | | Good luck, | -Rusty | | | | | | Jason Porter <[EMAIL PROTECTED]> wrote: -----BEGIN PGP SIGNED MESSAGE----- | Hash: SHA256 | | I took some freelance work to improve the speed of a site. I've done | all of the things that I could think of, improve the includes in the php | code (instead of doing url includes to the same site), configure | mod_expires, mod_deflate (site is on apache2 (2.0.52)), I've even gone | so far as to install eaccelerator thinking maybe it was PHP stuff. | Sometimes the site loads really fast, other times it takes 20 seconds to | load up the site. PHP is running in CGI mode, which may have something | to do with it (php 4.3.9 BTW). | | Box is a coloc box running RHEL ES 4. There's hardly any server load on | it, top shows it typically staying around 5% or less on the CPU load. | He has 60ish sites setup as virtual hosts and they each have a few | mod_rewrite rules, but this really shouldn't be much of a problem. | | Anyone have experience in tweaking apache or troubleshooting slow sites? | ~ I'm currently at a brick wall, I have no idea what to look at next. | - -- | | - -Jason Porter | Real Programmers think better when playing Adventure or Rogue. | | | | | --------------------------------- | Never miss a thing. Make Yahoo your homepage. | | _______________________________________________ | | UPHPU mailing list | [email protected] | http://uphpu.org/mailman/listinfo/uphpu | IRC: #uphpu on irc.freenode.net |
Thanks for the ideas Rusty. I've already looked at the database (that was my first thought). I added a bunch of indexes and looked over the queries. The stats stuff is something I haven't tried and firebug has been on my box since 0.5 or something like that :) Any other thoughts from the list? - -- - -Jason Porter Real Programmers think better when playing Adventure or Rogue. PGP key id: 926CCFF5 PGP fingerprint: 64C2 C078 13A9 5B23 7738 F7E5 1046 C39B 926C CFF5 PGP key available at: keyserver.net, pgp.mit.edu -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHyZFkEEbDm5Jsz/URCIfIAKDk2WKsmFZ1M530ZoeNpzpLS9XdZQCeM6ju ++Jizaz2IYCtb4xvrmeUmwc= =zksq -----END PGP SIGNATURE----- _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
