• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

how many databases/tables

Hi there

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

0
davoman
Asked:
davoman
  • 2
  • 2
1 Solution
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<I was wondering how many individual databases i can set up on one SQL server>> Theorically as many as you want.  What matters is not the number of db's but rather the overall space occupied...

<<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.>>  Really depends...Logically, centralizing data in one database is a better choice for performance and reducing administration costs.  Legal aspects should be taken in consideration seriously, as a client may not happy knowing his data is physically mixed up with some other's client...

Hope this helps...

Racimo
0
 
davomanAuthor Commented:
The performance aspect is interesting here, would it be lesser performance having more databases with less tables in it that a huge database with masses and masses of tables

the client data would be stored in seperate tables as their would be slight customisation for each
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<The performance aspect is interesting here, would it be lesser performance having more databases with less tables in it that a huge database with masses and masses of tables>>  Multiplying db's does not help at all as each additional db  requires additional context of execution which hinders performance.  Using one db, with data spreaden out over separate disks or appropriate RAID configuration is a safer approach to optimizing and scaling up.  Hope this helps...

Racimo
0
 
davomanAuthor Commented:
thats some real good info thanks for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now