Setting Up An RSS Database Structure
View PDF | Print View
by: Admin
Total views: 85
Word Count: 405
One increasingly important concern that many people face nowadays is the need to set up an RSS database structure in which feeds can be stored. The solution to the problem is a lot more straightforward than it would seem, although you wouldn't be able to tell from the few suggestions that can be found on the Internet. The fact of the matter is that if you have even a simple RSS database, you actually have a means to store feeds right at your fingertips in the included tables: Feeds and Items.
Now while this solution may be sufficient for most scenarios, websites that have feeds from the frontpage in addition to the category feeds might run into some problems. This is because the same posts usually appear in more than one feed, which will result in plenty of duplicated data in the RSS database.
The options you have at this point are to accept the duplicate posts or to use a link table in your RSS database between the feeds and the items. While this might seem like a waste of space, the amount that this will take up is actually fairly insignificant. In any case, the space taken up will be worth it given the reduced risk of potential issues that you will have with your RSS database. That being said, you should be aware that adding a link table to your RSS database will almost certainly increase processing time, so you might want to link content and remove duplicates if the post isn't in any of your Rss feeds anymore, depending on your needs.
It would seem that the best possible solution would be not to make an attempt to optimize every bit of feed data at this stage in the development of your RSS database. You would probably gain more benefits by making sure that your RSS database is up and running smoothly. After you have done this and you are still concerned about saving space, you can then decide on whether or not you should indeed make an attempt to save a certain percentage of space by using links or by sharing data between feeds. Of course, it would still be best to do so only if the reclaimed space is worth the time and effort it would take to optimize your RSS database.
About the Author
More articles about syndication, read fastfatloss4all.com.
Rating: Not yet rated