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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2007-07-05 : 11:30:30
|
| Hi all,one doubt abt db/table design. If there is a 7 to 10 billion (approx 70 to 100 crore) records expected in a table. How to keep this info. Can any one tell me db & table physical & logical design structure. let assume.. only 5 columns.. 1000 concurrent users, there will be bulkinsert (20%), more select (60%), delete (10%), update (10%) batchid varchar(20)bankid varchar(10)chqno varchar(15)chqamt numeric(17,2)chqdt datetime can any one tell me how to keep the db & table in a server/multiple server and if possible get me some server configurations also.Thankskrishnakumar |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2007-07-05 : 17:17:49
|
| it seems no gurus are interested to answer my questions |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-05 : 17:29:55
|
| You responded like that after only 6 hours!Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2007-07-05 : 17:48:53
|
| No still i am waiting for the answer |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-05 : 18:16:35
|
| "it seems no gurus are interested to answer my questions"I read your question and didn't answer, before, because I decided that if you are in the business of creating such a system you should not be asking for basic advice about how to go about it on a forum such as this.It requires far more thought and experience to make those sort of design decisions than you can reasonably expect to get here, as the answer depends on so many factors about the requirements of your system, not just the fact that you want a table to hold 10 billion rows.If you don't have the experience in-house then you need to get some consultants in to assist you.Kristen |
|
|
|
|
|
|
Table Design