As regulars may of noticed, the speed on Neowin has dropped dramactically over the last few weeks, we have been pulling our hair out as to why and found out that our mySQL load was way above its intended limit.
Our script was totally dynamic, meaning visitors got the page rendered straight out of the database with the latest content. A refresh was not necassary as it is pulled from mySQL everytime. I wont go into figures about the mySQL, but we were asking it to do more than it could.
Since we are now hit up to 50,000 times a day by unique IP addresses, thats alot of queries.
We have addressed this as promised
Phase 1 is, output a file saved on the server to the main page. The only mySQL queries being done now is when we Admin update the news, which makes mySQL update the file from the database.
Phase 2 will be, out-putting the comments in the same way, and adding features that we have pulled (poll, site stats and possibly Personal Welcome text)
Neowin is now updated to this new method, so we hope to see an overal performance increase, effective immediately, I want to thank our host Hosttyme, Redmak for his coding of the Recent Forum Posts (and much more) Also to Tingle who is the master of this script, and just converted this from Dynamic to Semi-Dynamic.
Update: We pulled the Welcome text, this will be put back as soon as possible, Views are gone. Headline View will be back, it will double up as the archive (and will look the same) ALL features that we had will be put back OK? we just need to do this in the right way without killing our server LOL.
Thanks to everyone who supports Neowin. We really appreciate it alot.
-1 Comments - Add comment