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