A question for the EvNet Dev Team

Posted By: fivestrokes | Aug 22nd, 2006 @ 3:34 AM
page 1 of 1
Comments: 0 | Views: 1495
#Aug 22nd, 2006 @ 3:34 AM
fivestrokes
fivestrokes
brrrrm! brrrrm!

After watching your video, I got very curious on one aspect in particular. You mentioned every record is now an "entry", i.e. video, podcast, post etc.

That would mean you have entries reside in a big table, with tags used for context. I have a couple of questions:

  1. How does this play on perfomance, especially with search, indexing? I have always assumed you can get better querying performance, if you separate the content into respective tables.
  2. Can you post a grobe sketch on the DB model for such an implementation?

I have always separated the content, i.e. forums table, download files table, etc. for added efficiency. But now I wonder if that makes any difference with a modern DBMS. I'm inclined to switch to your approach (i.e. if its not patented methodology Smiley) and would like to know more about the technical pros/cons.

EvNet Dev Team ... any thoughts please?

Many thanks.

page 1 of 1
Comments: 0 | Views: 1495
Microsoft Communities