Web lists-archives.com

Re: When to create a new database

When I read the OP I was thinking: This is one for Reindl. And here we go.

When dealing with data of this specific kind, you most definitely
would want a date reference. A very small computer will be able to handle
mane years of all kinds of weird sports statistics.

You need to define the goal you are looking for, and then ask the question.

On 2015-10-10 21:48, Reindl Harald wrote:
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

+66 8701 33224

This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql