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 15,2004 12:00am -I made a ton of updates today - vers.3.2 - post by the_reverend  [link]
profiles page
*updated discussion link to go from 100-1000's of SQL queries to 11-12. it was one for each post the user made (to get the subject). they are combined now into one slick call.
*updated cd-add link to go from 1 SQL call per CD-Added to 1 call for ALL cds added.
*updated CD-review link to go from 1 SQL per CD-Reviewed to 1 call for ALL cds reviews
*updated picture comments link to go from 1 SQL per picture comment to 1 call for ALL pictures commented on

All Pages:
*Moved a check from when RTTP was lost in July 2003 for usernames that are no longer valid due to them being lost with that server.

Main Page:
*removed 5 SQL calls from the main page by using the same method as the profiles page uses for CD covers on the latest reviewed section
*removed the separate looks ups on picture comments. another 7 SQL calls replaced by 1.

Search Page:
*restructured so that the Search thing is on the top of the results page.
*cache searched values so that I can do a "top 10 searches"
*Turned all the CD-reviews and CD's search into 1 sql command. Was one PER cd found. (this needs to be monitored for time which bad! it takes about 20 seconds for this query to work!)
*Removed superfluous sql query on the discussion list for the subject since I already know that info.
*replaced 1 SQL query for each picture comment found on the picture comment search.

CDREview.php:
removed 1 SQL command for all the other CDs by whatever band. also, removed duplicate queries for the CD covers on the most/last section

removed some crappy update stuff from index.php, equipment.php, and bullsiht.php

allpictures.php:
redid the referrals 1 SQL query PER pictures to 1 for all 60 pictures. 76 sql queries down to 12.

view.php:
*fixed some times where it posts as anonymous when you are logged in.


REMOVED FUNCTIONS:
lib.php file
getPictureInfo();
getCdInfoLink();
getDiscussionBoardInfo();
getCdInfo();
getCdCover()
getConcertDescription()
getPictureBandName()
userLoginUpdate()
getCdInfoLink()
lookupUser($user);

search.php
getPicture()

allpictures.php:
getLinkedPicture()



[default homepage] [print][2:15:16am Mar 23,2017
load time 0.01793 secs/9 queries]
[search][refresh page]