Mar 29,2006 12:00am -Holy updates! speedspeedspeed - vers.3.5 - post by the_reverend[link]
I'm trying to speed the server up more and more. in that, I'm working to get out a few things.
1) the length of names on the messageboard is now a lot smaller. I think it's 65 characters. this allowed me to set them as INDEXES for the USER that started a thread (27K fields), the USER that responds to a thread (27K fields), and the USER from the posting table (400K fields). this sped a TON of queries on the message board tables up by up to 4x. yeah for me. there was a minimal hit in the time it takes to post a thread, but whatever.
2) the events tables is now written differently. there is a separate userevents table where the personal events from the events table are stored. please, test this out and see if it's working correctly. this effects the shows listed on your profile as shows that you are going to attend. this was the test-case for me taking the bands news into it's own indexed table. I was also able to change the HUGE field that stored the info before into a much smaller field.
3) ok, I updated the message board/bands page so that the news is in it's on table and the news field is soooo much smaller. this will cause the bands page and the discussion board to work a lot fast. check it out.
Also, there is now very ridged spam and IP blocking going on. I have blocked off something like 1500 known anonymizer proxies as well as every single IP that has been caught posting spam on the site. fuck them.
the pictures.php page is now showing the date and post processed pictures again.