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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Multiple databases

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
Go to Top of Page

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 database
2. 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 ?

rgds
Afrika



Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-21 : 09:34:25
Well, first you don't even mention that you have a problem...

How much data are we talking about?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

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.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-21 : 10:07:53
quote:
Originally posted by afrika

Data ? in table size or backup size ?

largest table is 800,000 rows.



Well that's really nothing to even blink at

Do you have a projected growth?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -