Web lists-archives.com

Re: When to create a new database

Am 10.10.2015 um 16:28 schrieb Richard Reina:
If I were keeping tract of high school sports statistics and thus designed
the following tables:

sports, rules, statistical definitions


players, teams, games

Would it be a good or bad idea to put the first set of tables in a separate
database called "library" since they are used for reference and rarely
change? What would be the pros and cons of using two different databases?

it makes zero sense since you can use different users for the same database down to table and even column permissions

with default (crap) settings innodb anyways stores all in the same big file, and file_per_table is, well, per table

Attachment: signature.asc
Description: OpenPGP digital signature