In general principle is one better to place lots of tables in a single database, or to divide tables across multiple (smaller) databases?
As traffic volumes (both in terms of simultaneous connections and complexity of query) on the mySQL server increase what, in principle, has the great impact on server performance;
1. table type (myisam versus innodb),
2. connection type (persistence); or,
3. the division of tables across single or multiple databases?
I’m sure if I pop along to the Safari Bookshelf I’ll find whole books dedicated to this, but, in a nutshell, is the a rule-of-thumb I can follow?
JiF
One day someone sensible might have to clean up what I’m doing now. I want to make it easy as possible for them..😉