Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    1

    Post Table design and database performance

    I want to gain some data support about using normalized database is better than denormalized database because another development team suggest to break down some large tables into so many smaller tables, they think that can speed up the performance of database. But, I don't agree with them. Therefore, there involve some many arguments, such transaction time, query time, and so on.

    Do you have any research result or data that can prove which database design is better? What's the best database design methodologies if these databases are distributed in three or more locations and they will replicated frequently?

    Ming

  2. #2
    Join Date
    Dec 2001
    Location
    Delhi/Bangalore, India
    Posts
    74
    You can try to get case studies at www.searchdatabase.com

    If nothing else works, hand over an elementry database design book to the targets.

  3. #3
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    http://www.dbdebunk.com/ has a lot on the topic.
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •