For speed multiple or single database makes no difference. For SQL I would stick with one if all the data is related. Index any thing you are going to select on. So if you have a user database you would index name and password not there age and job title.
Simon ----- 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? > > > --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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