One database versus multiple databases
Posted on 2010-01-06
I have a website that contains multiple different web based applications. Some of the applications contain quite alot of data and is used nationally on a daily basis.
I'm wanting to know is it better to create multiple databases for each of the highly utilized applications and link all the databases together or have one database that contains all the tables for each of the different applications.
So...1 Website, 5 major applications. Do I have it so I have DATABASE01 with every table from the 5 major applications along with the rest of the tables needed for the site? Or do I have DATABASE01 with all the tables needed for the site and the minor/small applications, then create DATABASE02 for Application1, create DATABASE03 for Application2, create DATABASE03 for Application3, create DATABASE04 for Application4, and create DATABASE05 for Application5...then link the separate databases to each other so they could be queried together, if needed.