if you can affect closure without artificial constructs, then it probably belongs in a single database. if closure can't be affected in the logical design, then you probably need multiple databases.
if you don't understand the concept of a relational database closure, refer to http://www.coremodel.com mysql > > ----- Original Message ----- > From: "William Martell" <[EMAIL PROTECTED]> > To: "MySQL Main List" <[EMAIL PROTECTED]> > Sent: Monday, November 11, 2002 2:02 PM > Subject: SCHEMA, ARCHITECTURE ??? > > > > Hello All, > > > > How do I determine the best architecture for my MySQL database? > > > > Do I create multiple databases or do I create only one database with > > multiple tables? (Any general rules of thumb?) > > > > How do I know if I need to use Keys, Indexes or other features in order to > > optimize the database? > > > > > > > > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
