Jun 11,2004 12:00am -Major speed inprovements with this site - vers.3.2 - post by the_reverend[link]
I looked at my site stats and figured out how I could speed up pages based on how many views the pages get.
/media.php changed from about 10 SQL calls to 3-5 calls
/pictures.php 10 SQL calls to 3-5 calls
/top.php this one was a bitch! looks like to initially load this page it made like 15 un-needed SQLs! I removed all that and cleaned up a bunch of others so that it's quicker to load up.
/amimetalornot.php 15 SQL calls to 5-10 calls
/profiles.php took out about 2 calls here
/concert.php I made a 1 SQL change here. once I fix the whole "extra-location" thing, this should speed up a lot.
/band.php fixed somethings on this that I don't remember
/main.php re-wrote this based on the "extra-location" thing. it was 5-6 SQL calls for EACH concert displayed. I changed it to 1 SQL that contains 3 JIONs. I'm hoping that this doesn't actualy slow things down.
/login.php I fixed something here, but foeget what it was
/events.php change those 250 SQLs to 10...
I also made it so that only 3 pages (the 3 forum pages) load the discussion icons. previously all pages were.
current SQL/second is over 35. I'm hoping to get it closer to 20.