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 - 2001-07-18 : 19:15:41
|
| Paresh writes "Sir,I am a Programmer . I am i a fix due to the problem that i am facing. The problem is that there are two Database Design model from which i have to choose one so as to achive maximum effecieny of my application. I write this problem with, assuming that all the profiles of my Clients are the same and they deal in the same kind of the businness.The two Database Design Model are1)This where i create 6 tables in my database with the stored procedures and the triggers relating to each table. This where i store data about my Client's and his Customers. Here data about all the clients and their respective customers are stored in the above tables. which i am doing using their id's and certain more things.For example,I have 20 clients and each client has 200000 customers and all the info are being maintained using same 6 tables.2)This is second model where i create 6 tables for each client and its customers . Each Client and its account are maintained seperatly . For example there are 10 clients then i have 10*6=60 tables to keep their data.Please, let me know which design i should follow to achive maximum effecieny and scaliblity for my applicationMy e-mail address is paresh_joshi10@yahoo.com.,if the solution could be posted to the e-mail address.Thanking YouParesh Joshi" |
|
|
|
|
|
Database design