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 - 2003-09-08 : 07:27:16
|
| Jamie writes "I want to build a data center that will have upwards of 1 million clients in the database. At any given time 5000+ customers could be searching for any one client in the data base over the internet. Also, at any given time 5000+ customers could be adding new clients to the database over the internet. I wonder what the best design could be to facilitate this. Money and hardware are not an issue and I have an OC12 connection to the internet. Reliability and redundancy are critical. I am testing with one write and one read only server. I have heard of sharing the query between multiple servers which would search segments of the database but am courious if this is the best way?" |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-09-08 : 08:07:08
|
quote:
Money and hardware are not an issue
Wow, what company do you work for??!! Is this for real?!  Jamie, one million clients sounds like a real lot, what exactly do you mean by clients? I think we will need a little more information from you on this system, what kind of searches? What is the expected database design like?If you really have a lot of data in a few lean tables, vertical partitioning should give you a decent performance boost, but again this depends on a whole lot of factors. Owais
Make it idiot proof and someone will make a better idiot |
 |
|
|
|
|
|
Optimized Search Design