November 10, 2009 at 5:03 am
I have a Hospital Management System. The hospital had multiple branches. I laid the database structure like this. The masters I had it one Masters database and for the various transactions I had one database for one branch. Meaning if there was a new branch I would add a new database(all the databases are in a centralized server). Almost 6000 patients visit the hospital (all branches) per day. I am developing a asp.net application I thot of having a single database for all the transactions will the database be able to hold such huge amount of data or is it better to go for one database per branch. Experts your comments pls
November 10, 2009 at 10:52 am
when you say all the databases are on a centralized server.. you mean on the same sql instance?
If they are.. then I don't see the point in multiple databases assuming the structure is the same throughout.. at some point you'll want to compare data across all of them I'm sure, in which case you'll have to join multiple databases.. if you keep your tables well laid out with appropriate keys and indexes.. there is no reason why they can't all be in one database.
On the other hand.. if they have different schema's for whatever reason, then multiple databases may be the way to go.
Personally, I'd go with the single database with a well laid out schema for ease of use and maintenance (maintaining 1 large database as opposed to several smaller databases), ie. updates to your application will need to be propagated to multiple databases at once etc.
There are plenty of arguments both for and against.. it really depends on your core needs.
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
November 10, 2009 at 11:50 am
The only real limit on how much data your databases can hold is the size of your hard drives, unless you're using Express edition. If you're using Standard or Enterprise, then 6000 entries per day should be easy to deal with in a single database. 6000 entries per minute is no big deal for most database servers, much less 6000 per day.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply