an online system i am setting up needs a lot of back end customisation for each client.
I was wondering how many individual databases i can set up on one SQL server
or how many tables can i have in one database.
and also which would perform better, a database for each client with the tables in or a single database with all tables for a ll the clients.
The central core of the information being stored by the client is indentical but they are allowed custom fields etc which will be displayed on a web page.
I'm trying to get my head round the best way to do it