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