Distributed or Federated Servers
-
hi I am making a software that will handle a database of 5 crore records. Please help me how to handle these many records. How should I design the database? shelly
-
hi I am making a software that will handle a database of 5 crore records. Please help me how to handle these many records. How should I design the database? shelly
hunjan wrote: a database of 5 crore records. I'm not sure how you mean - 5 core records of what ? If you gave a little more info, perhaps we could make a suggestion. What's a federated server ? How is that part of the DB design ? What are you storing exactly ? Christian Graus - Microsoft MVP - C++
-
hi I am making a software that will handle a database of 5 crore records. Please help me how to handle these many records. How should I design the database? shelly
The only reliable way to tell what level of hardware you need to run on is to load test your application. Proper design and indexing can typically make a performance difference of 10-100x. So a well designed and implemented system can easly run on a tenth of the hardware of a poorly designed one. BTW I've worked on non-federated SQL servers with billion row tables and thousands of concurrent users and as long as we kept everything well tuned we didn't have any problems.
I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon