3 ms·

What would be the best, different tables per customer or different db?

• brianwawok 6y ago
  There’s overhead both ways. Multi-tenant is more efficient. What is the most possible users you could have in 5 years? Can your choice be supported in that technology?
  • gomox 6y ago
    Enterprise systems have little to no cross-customer functionality, and customer isolation is paramount. I think you are assuming that they will have a database per individual user, but the original question pointed to "tenants" (i.e. companies using the system).
• gomox 6y ago
  What I have experience with is separate DB, and separate applications. Then basically you orchestrate a bunch of applications, a task for which a myriad of tools already exist.
• brigandish 6y ago
  There's always schema to consider too, you can have thousands of them too. An often overlook tool.