[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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