Speeding up a SQL Database
My names Russ, and im the lead designer of www.clubskill.com one of the largest UK online entertainment portals. We've recently purchased and slightly modified www.vgportal.com/scripts, a gaming CMS. Sadly, for one reason or another, the site is loading VERY slowly. We've checked the server, and anything that dosent run off the SQL database is absolutly fine and loads up almost instantly. So we've come to the conclusion that its the crappy coding of the CMS.
Does anybody have ANY ideas how we could speed up the loading time of the database. WE're worried that the 20,000+ uniques we get per month is going to drop if we cant get the site loading faster... ANY help would be fantastic PLEASE! :)