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
and
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
--
Mogens
+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
