Re: Storing RSS web feeds in the db?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Jacob Sebastian" <jacob.reliancesp@xxxxxxxxx>
Date: Thu, 25 Sep 2008 18:10:20 +0530

I think the answer depends on what you want to do with the aggregated feed. As far as storage is concerned, it is a good idea to store as an XML document. But if this document is frequently queried/searched, then shredding the data to relational tables might be a better choice.

--
Jacob Sebastian
SQL Server MVP
http://www.sqlserverandxml.com

"Hillbilly" <somebody@xxxxxxxxxxxxx> wrote in message news:enAfgdDEJHA.1280@xxxxxxxxxxxxxxxxxxxxxxx

Have any best practices been learned to store (aggregate) RSS web feeds in the db? Shred or XML data type or what? Any design documents I might be referenced to? Which coding methodology to "get er done?"

References:
- Storing RSS web feeds in the db?
  - From: Hillbilly

Prev by Date: Re: Can't insert xml into xml column even when schema is followed?
Next by Date: Re: Can't insert xml into xml column even when schema is followed?
Previous by thread: Storing RSS web feeds in the db?
Next by thread: Nonclustered index which includes XML column
Index(es):
- Date
- Thread