Correct model for a database with a table for each user.
- by BAH
Kinda stuck here... I have an application with lets say 5000 rows of data per user and was wondering if it was right or wrong to do it this way:
On user account creation a new table is created (UserData_[UserID])
or should I just have 1 table for userdata and have everything in there with a column for userid?
The reason I am stuck at the moment is that it seems NHibernate isn't able to be mapped to dynamic table names without creating another ISessionFactory which has alot of overhead AFAIK.
Any help would be greatly appreciated.
Thanks.