Single vs. Multiple DBs || Which way to go?

From: Date: Sat, 08 Feb 2003 18:28:55 +0000
Subject: Single vs. Multiple DBs || Which way to go?
Groups: php.general 
Request: Send a blank email to php-general+get-134874@lists.php.net to get a copy of this message
Hey all. I'm attempting to organize a sport report site into working order. We've got approximately 100 tables, and I'm unsure whether to break the info up by sport (i.e. baseball, basketball, hockey, etc.) or to lump all the tables in one db and prefix tables by their sport name (e.g. bk_scoring = basketball scoring table). On the surface, it would seem easier to use multiple dbs, but then again, common tables, such as schools and coach_info would have to be duplicated in each db. Any ideas/suggestions much appreciated, --Noah --

« previous php.general (#134874) next »