Re: When to create a new database
- Date: Sun, 11 Oct 2015 01:09:35 +0700
- From: Mogens Melander <mogens@xxxxxxxxxxxxx>
- Subject: 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 definitelywould 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 designedthe following tables: sports, rules, statistical definitions and players, teams, gamesWould it be a good or bad idea to put the first set of tables in a separatedatabase called "library" since they are used for reference and rarelychange? 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