I building a software that is going to have a lot of users (hopefully) I will have users that dont have much records or exceed normal data and I would also have the big users which will have millions of data rows in many tables. What would it be better putting each user in a separate database or having a master database for all users even thought data could get very large in records. I am worried about performance, would SQL server still be able to perform as normal even after millions of records for each user? The structure of the data would be the same since they will be all talking to the same software.
Any ideas? Thanks.