Link to home
Start Free TrialLog in
Avatar of coreybryant
coreybryantFlag for United States of America

asked on

Site With Multiple MSSQL DBs

I have a few sites that use MSSQL db.  Is it better to create a MSSQL DB for each of their programs.

Would it be better to use one MSSQL DB for each script or to have one DB for them all?  Thank you!
Avatar of John Easton
John Easton
Flag of United Kingdom of Great Britain and Northern Ireland image

I guess it depends what you are doing.

If the site are totally seperate and have no intergration then I would usually use a seperate database for each.  This potentially has security advantages if one site gets hacked.

Also, if a site is going to have a huge amount of data you may prefer to split this into multiple databases.

However, if the sites do interact however, then one database may be easier.  I.e. one site which is for sales staff and another public site for customers but they share product lists etc.

If you provide more detail of what the site are you may be able to get better advice.
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of coreybryant

ASKER

Thanks all - I would definitely create one MSSQL DB for each site.  I just did not know if having multiple MSSQL DBs would cause the site to load slower.  

I am not worried about having scores of DBs (when it comes to the hosting part).   Basically, some websites have a MSSQL DB for the information that will be displayed and another DB for another script that is being ran on the pages.  Plus some might have an 'ad script' with its own DB.  

So opening one page could possibly need to get access to three databases.  

On one of the scripts, the tables start with an mt_ - so I doubt I would have issues with that.  I have not looked closely at the other names of the tables, but I would think that if the other two scripts have a table named user that might cause some problems.   Of course, I could change one script to begin with ad_ - although that seems like a lot of work.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks - since I was getting ready to move the sites to another server, I wanted to make sure that I started things off right