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:
-Original Message-
From: William Martell [mailto:willmartell;yahoo.com]
Sent: 11 November 2002 20:02
To: MySQL Main List
Subject: SCHEMA, ARCHITECTURE ???
Hello All,
How do I determine the best architecture for my MySQL database?
Years of painful but fulfilling experience :)
Seriously