After spending some time thinking about different ways to re-enable the RSS feature for the-spot.net, I’ve finally hit on an idea that I’ve started writing the code for.
The original code would hit the main database to grab the newest posts on the forums…after it sorted all 77000 posts by date, and then grabbed the top 15-20 of them and their data. Since the entire site runs off of that one database, you can imagine how that would slow down everything when even just 10 people hit the site every 15 minutes.
So I am going to attempt my first distributed database scenario. With this new code, when you make a post, it stores it to the main database as well as some of the data to a second database on another server I have. This setup will send only the relevant data for producing the RSS feed, and when the RSS page executes, it will run on that data.
I’ll give more technical details about this code in another post for those that are interested. This is just to let everyone know that there is something being worked on for the site, even though you don’t see a whole lot being done up front.