1 Reply Latest reply on Oct 14, 2015 7:47 AM by S.Williams

    Separate databases or just more tables?

    S.Williams

      So what is the "best practice" on deciding when to use another database or just add more tables to a single database?

      And how many tables is too many in a single database?

       

      for example: say I have a CRM project that has a database with 12 tables

      I now want a project management system that needs another 12 tables but it could also use a table or 2 from the CRM system.

      Then later I need a Venue management system that also has a bunch of tables but could use tables from above also.

       

      In general I guess I'm asking, when is it time to create another database -vs- just adding more tables and what considerations are there.

       

      Thanks!