Web lists-archives.com

Re: When to create a new database





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
data_teams
data_games

Ron

On 10/10/15 10:28, Richard Reina wrote:
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?

Thanks



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