August 4th, 2006

saxophone

Database/PHP efficiency?

I'm writing, essentially, a php-based RSS aggregator. The program downloads the RSS feeds for each of my friends and stores them in a database.

The PHP script then takes each of the RSS feeds, parses them, orders them, and spits them back on to the screen.

Should I just store the entire RSS feed in a db text field and use PHP to sort them (using PHP's array sorts?), or should I have a separate table where each record is an individual post from the feed, and then use mysql to sort them? It just seems like that is an extra table that can get very large (tens of thousands of rows) and add an unnecessary layer of complexity to the database?

Which is better/more efficient?