Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-11-21 : 07:50:33
|
Hello,Our database design is increasing as we are adding communities and other 3rd party products to it.Just a quick question about partitioning databases, would it be wise to have multiple databases ???Any real world expiriences to share ?afrika |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-21 : 08:24:31
|
that's a very broad subject.you'll have to give more info about your specific requirements.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-11-21 : 08:47:59
|
Ok, more like this.1. We have a site that runs online communities, which was built from scratch.2. We purchased a few software. e.g. Java chat applications, and a comprehensive forum. (Which all come with their own proprietry database)Now these additional database have added to the volume of tables and SPs we have. And we want to partition the database, so that. 1. Our inhouse developments lie in one database2. The 3rd party products lie in the other.however, this would mean two connection strings and multiple queries when loading the welcome users restricted page.So am just seeking advice on whether its neater and more perfomance driven to leave it or migrate to two DBs ?any advice, examples ?rgdsAfrika |
|
|
X002548
Not Just a Number
15586 Posts |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-11-21 : 10:05:54
|
Data ? in table size or backup size ? largest table is 800,000 rows. |
|
|
X002548
Not Just a Number
15586 Posts |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-11-21 : 10:14:13
|
Its a fairly new project we started a while back. Projected growth ? Yes, we anticipate not more than 5-10 million entries per table |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-21 : 10:19:14
|
well if your 2 db's are completly separated in regard to user permissions and data integrity then you probably won't have any problems.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
|