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.
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.
Microsoft Game Studios presents five exclusive titles at launch, including:
- "Halo" the much-anticipated sci-fi shooter, takes place on a mysterious alien ring-world. Packed with combat, "Halo" will have players battling on foot, in vehicles, indoors and outdoors with alien and human weaponry. The objective: to destroy mankind's sworn enemy, the Covenant.
- "Oddworld: Munch's Oddysee>/b>" brings Oddworld to life in full 3-D. Players embark on a journey through a changing world of oddball creatures, off-the-wall action and outlandish goons. Players guide aquatic Gabbit champion Munch(TM) and Mudokon partner Abe(TM) in their third adventure across Oddworld.
- "NFL Fever 2002" combines fast and hard-hitting action with deep season and career modes. Featuring stadiums from all 31 NFL teams and enabling players to participate in up to 25 seasons, "NFL Fever 2002" allows players to amass both individual and team trophies as well as build dynasties, season after season.
- "Project Gotham Racing" is the future-generation racing game where fun and reward come from focusing equally on speed, flair and risk-taking. Players choose from more than 25 different cars and compete on more than 200 city-based circuits in photo-realistic downtown environments in San Francisco, Tokyo, London and New York.
- "Fuzion Frenzy
" is a nonstop party game with an edge, combining the continuous, frenetic action of a futuristic street sport with the action-packed fun of minigames. Set in a dynamic 3-D urban environment with six arenas and more than 45 minigames, "Fuzion Frenzy" provides competitive fun for up to four players.
"In addition to our blockbuster launch-week lineup, gamers can look forward to electrifying games to come in the near future from world-renowned publishers like Sega, Capcom, Namco, Acclaim, Interplay, Take-Two, Ubi Soft Entertainment, LucasArts, Crave and Sierra Entertainment"m said J Allard, general manager of the Xbox platform at Microsoft. "Xbox has arrived, and the future of gaming has never looked brighter."
Commenting has either been disabled on this article or you are not logged in. Click here to login or register, its free!
Note: Anonymous commenting is disabled in order to keep the quality of responses to a high standard.