snickwit

How to choose to add new table vs new database (related dbs)?

Discussion created by snickwit on Sep 27, 2012
Latest reply on Sep 27, 2012 by cortical

Hello,

 

I haven't found anything that discusses when one might decide to add related data as a new table in existing database or new database. My general thinking would be to create a new table if it's related data but how does one determine or make the asessment if that might make the database too bloated or affect performance? What are the cons or impact of adding as a new table vs new database? For example, what's impact if you decide to add as table in existing database but later have seperate database and now need to relate to the table in other database?

Outcomes