Making Your Database Sites Faster

[Guest lorph]

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.

[section31]

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

[borfast]

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...