?

Log in

No account? Create an account
August 4th, 2006 - LiveJournal Client Discussions — LiveJournal [entries|archive|friends|userinfo]
LiveJournal Client Discussions

[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

August 4th, 2006

Database/PHP efficiency? [Aug. 4th, 2006|04:40 pm]
LiveJournal Client Discussions

lj_clients

[gargoylemusic]
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?
link4 comments|post comment

navigation
[ viewing | August 4th, 2006 ]
[ go | Previous Day|Next Day ]