gargoylemusic (gargoylemusic) wrote in lj_clients,

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?

  • 302: lj_dev

    In the interests of consolidating all LiveJournal development-related discussion, we're going to be closing down this community. The same…

  • Plain text to LJ

    I have an old blog from xanga that's in html/plain text and I want to move it over here. Which client would be the best to do this? I also want to…

  • ljKlient 0.2.0 Preview Release 1

    Today marks another milestone in the development of ljKlient — as the first preview of the 0.2 series is released.  Please go to the project…

  • Post a new comment


    Comments allowed for members only

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened