Guest lorph Posted June 21, 2005 Share Posted June 21, 2005 Will mySQL run faster by having all the tables lumped together in one database? Or should the tables be organized into multiple databases? Maybe it wouldn't make a difference. I have a feeling that only a benchmark would show but maybe someone here knows. Quote Link to comment Share on other sites More sharing options...
section31 Posted June 21, 2005 Share Posted June 21, 2005 (edited) If you aren't going to be accessing tables from the other databases, I'd keep them seperate. It makes things a whole lot easier when backing up, restoring, etc. Edited June 21, 2005 by section31 Quote Link to comment Share on other sites More sharing options...
borfast Posted June 22, 2005 Share Posted June 22, 2005 Try separating them by application - 1 database for an online discussion forum, another for the sales software, another for the tech support software, another for your blog, etc... 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.