Hello, I am trying to provide some kind of hosting system to my clients.
I am now thinking of automatically creating a new database and a new user when they register. But I am concerned about the scalability of this approach.
I can aswell put all the data to one database and give foreign key to users that I know who owns which data. But this will make my searches much longer.
The problem is there won't be MANY users but they will save MANY data.
And I want to be able to save, reroll, close, open the database of a specific user, this is more easily done with multiple databases I guess.
Soo.. would 50 or 100 databases create much overhead on todays computers? Is it simply acceptable?