Ass Hat
Home
  About
  Equipment
  FAQ
  SiteUpdates
  Help
  SubmitMusic
  Portfolio
  onMyspace
  onFacebook
  onWIKI
  onBlogspot
  onWordpress
  onLiveJournal
  onBuzznet
  NewsLetter
News
Events
Bands
Labels
Venues
Pics
MP3s
Radio Show
Reviews
Releases
Buy$tuff
Forum
Miscellaneous
Links
E-mail
Search
End Ass Hat
login

Webpage Updates

: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.



[default homepage] [print][2:18:38am Mar 23,2017
load time 0.01692 secs/9 queries]
[search][refresh page]