Duplication of Database per customer
I have built a large database application that will will service 20 customers. Each customer services between 60 and 200 customers and each of their customers has between 50 and 1200 users.
I am trying to figure out if I should keep everything in one database or break each of the 20 primary customers into their own database with the same structure. On login I can determine what database to select for the client or sub client based on an organizational ID ie ORG id 205 would reference 205databaseName
Is this efficient or am I better off just keeping the data in one database structure and not breaking things out.
Subject
Written By
Posted
Duplication of Database per customer
December 07, 2021 01:09AM
December 07, 2021 12:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.