The Little Guy Posted October 27, 2008 Share Posted October 27, 2008 I am in the process of building a site... The site has: Movies Images A Social Network Games Website stats (8,253 records = ~3MB) Website help (comming soon) (And what ever else I can think of) I also have a users table Currently all these tables are in one database. Expecting the site becomes fairly popular, would it be best to have one database with 50+ tables, or multiple databases with fewer tables? If I did multiple databases would I be able to do joins? Quote Link to comment Share on other sites More sharing options...
rhodesa Posted October 27, 2008 Share Posted October 27, 2008 increasing the number of databases can lighten the load, granted they are on different servers. but, if they are on different servers, you can't join them. if the site outgrows a normal database, on a decently stocked server, you're gonna want to look into a cluster Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted October 27, 2008 Share Posted October 27, 2008 increasing the number of databases can lighten the load, granted they are on different servers. but, if they are on different servers, you can't join them. If you use federated tables then you can join data on a remote server. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.