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

:Jul 22,2004 12:00am -Major Speed improvements - vers.3.2 - post by the_reverend  [link]
ok, the site's been slow lately due to the # of pictures in the pictures table and the number of discussion posts in the discussion board.

after a lot of reading, I changed the .35 sec average SQL call time for the main page to print out one concert ot .01 sec
same with any of the concert pages.

http://www.returntothepit.com/view.php?formid=7953
for the forum, the infamous "thread of death" with 400+ rows
before: took 6secs to load with no load on the server and 20 secs to load with average load
mid-way: made table indexing an int instead of a tinytext 3.6 secs with no load
after: no real cahnge from mid-way after set it indexing
edit: after removing the user info look up, a print out of the threadof death under no load was around 1 sec.

now, when a thread gets over 200 relies, the user info look up goes away to make it load faster.

www.returntothepit.com/amimetalornot.php?id=17253
for some reason that picture was removed from the am i metal page. I must have been switching from javascrip to php when that pictures as an example.



[default homepage] [print][5:17:19pm Dec 18,2017
load time 0.01864 secs/9 queries]
[search][refresh page]