Normalize or Denormalize in high traffic websites

Posted by Inam Jameel on Stack Overflow See other posts from Stack Overflow or by Inam Jameel
Published on 2009-08-01T19:13:25Z Indexed on 2010/03/14 1:45 UTC
Read the original article Hit count: 388

what is the best practice for database design for high traffic websites like this one stackoverflow?

should one must use normalize database for record keeping or normalized technique or combination of both?

is it sensible to design normalize database as main database for record keeping to reduce redundancy and at the same time maintain another denormalized form of database for fast searching?

or

main database should be denormalize and one can make normalized views in the application level for fast database operations?

or beside above mentioned approach?

what is the best practice of designing high traffic websites???

© Stack Overflow or respective owner

Related posts about database-design

Related posts about normalization