One table or multiple tables for data feeds.

  • steven420
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Oct 16, 2005
  • Posts: 100
  • Status: Offline

Post February 19th, 2009, 7:16 pm

Hi, I am building a site that uses data feeds from multiple merchants. My question is should I combine all the data feeds into one table (they are normalized) or give them their own tables? Which is faster?

Thanks,
Steve.
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post February 19th, 2009, 7:16 pm

  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Joined: Feb 10, 2004
  • Posts: 13455
  • Loc: Florida
  • Status: Offline

Post February 20th, 2009, 5:53 am

If I understand you right, I would use one table and create an indexed "source" column to keep track of which feed the row came from.
Strong with this one, the sudo is.
  • steven420
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Oct 16, 2005
  • Posts: 100
  • Status: Offline

Post February 20th, 2009, 12:53 pm

Thanks joebert.

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 165 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.