By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,966 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,966 IT Pros & Developers. It's quick & easy.

Splitting a DB?

P: 234
Hello All,

There are alot of threads explaining how to split a data base. My question is at what point does the developer decide that the split is necessary? Secondly, what are the pro's and con's of such an action? I have designed a dozen or so db's but, haven't deemed this action critical in their evolution.

Feb 7 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 108

There are several reasons one might split there database. One of the primary ones being data security and protection. Additionally, if you have multiple users using the same database it helps cut down on lockouts. Check this page out as it got into the basics of why and how to split a database as well as some pros and cons.

Hope this helps.

- Minion -
Feb 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.