When to create a new database

2015-10-10 Thread 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

Re: When to create a new database

2015-10-10 Thread Ron Piggott
I would lean towards keeping it all together because of the speed decrease between connecting to different databases. What I would tend to do is put some type of prefix that would keep the sets of tables together --- like lib_sports lib_rules lib_statistical lib_definitions data_players

Re: When to create a new database

2015-10-10 Thread Reindl Harald
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

Re: When to create a new database

2015-10-10 Thread Mogens Melander
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