PLease maintain only one database , You can have one user table with USER_ID ,
that user id can be associated with each row of job table , you can easily get all jobs for perticular User Id.
You can have millions of records in SQL database , with proper design( Normalization) and indexes you can get result very fast.
sameer.khanjit@gmail.com
View Blog Click "Mark as Answer" on the post that helped you.
Kasper55
0 Points
12 Posts
Different database to each user
Dec 30, 2012 10:19 AM|LINK
Hi
I want to have couple of databases, and when the user logs to the system, the system will refers to the user's specific database.
Expample:
Lets say I'm writing client managemt website. The user John will see only his clients, and not Jack's clients.
Best regards
urenjoy
Star
11997 Points
1797 Posts
Re: Different database to each user
Dec 30, 2012 12:03 PM|LINK
Basically, you have to change connection string dynamically in the code, have a look at following:
http://forums.asp.net/t/1524800.aspx/1
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: Different database to each user
Dec 30, 2012 12:46 PM|LINK
You don't need multiple databases. You just need to learn how to get the job done with one. Multiple databases is a maintenance nightmare.
Kasper55
0 Points
12 Posts
Re: Different database to each user
Dec 31, 2012 09:27 AM|LINK
Hi,
Thanks!
Kasper55
0 Points
12 Posts
Re: Different database to each user
Dec 31, 2012 09:29 AM|LINK
Hi Dan,
Actually I know the job, but each user will have thousands of records, and i'm gonna have a lot of users so i have to seperate the data bases.
Thanks anyway!
sameer_khanj...
Contributor
7046 Points
1376 Posts
Re: Different database to each user
Dec 31, 2012 09:37 AM|LINK
PLease maintain only one database , You can have one user table with USER_ID , that user id can be associated with each row of job table , you can easily get all jobs for perticular User Id.
You can have millions of records in SQL database , with proper design( Normalization) and indexes you can get result very fast.
sameer.khanjit@gmail.com
View Blog
Click "Mark as Answer" on the post that helped you.
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: Different database to each user
Dec 31, 2012 12:24 PM|LINK
No you don't. You need to learn data modelling. I've heard good things about the book, Database Design for Mere Mortals.
Kasper55
0 Points
12 Posts
Re: Different database to each user
Dec 31, 2012 03:20 PM|LINK
Thank you Dan
Kasper55
0 Points
12 Posts
Re: Different database to each user
Dec 31, 2012 03:21 PM|LINK
Hi Sameer,
Thank you.