Duplication of Database per customer
Posted by: Michael Keough
Date: December 07, 2021 01:09AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Duplication of Database per customer
December 07, 2021 01:09AM


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.