Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-30 : 08:00:51
|
| Mak writes "Helloi have database, contact information data(more than millions record)(like first name, last name, email, street,zip code and phone). my questions is how do i design this database? which is good horizontal or vertical desing , if i hold all datas in one table how fast i will reterieve particular record or match more record?thankskader" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-30 : 09:01:54
|
| Good logical design is one which reflects the requirements of your information needs.Good physical design is one which balances all the costs (performance and storage) of best meeting the logical design.Horizontal or vertical are not usual terms associated with database design, other than in the context of the phrase "partitioning"....so I'm at a loss as to what you are talking about here.How fast you can retrieve 1 record....it depends on the implemented physical design, quantity of data PLUS the quality of the physical EQUIPMENT you are using. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-08-30 : 09:32:10
|
my personal belief is that a normalized approach is the best in your case...and in every other case... Go with the flow & have fun! Else fight the flow  |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Database Desgin