Categories
Projects the-spot.net

New RSS Code in the works

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.

By [[Neo]]

I am a web programmer, system integrator, and photographer. I have been writing code since high school, when I had only a TI-83 calculator. I enjoy getting different systems to talk to each other, coming up with ways to mimic human processes using technology, and explaining how complicated things work.

Of my many blogs, this one is purely about the technology projects, ideas, and solutions that I have come across in my internet travels. It's also the place for technical updates related to my other sites that are part of The-Spot.Network.

2 replies on “New RSS Code in the works”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.