[Cialug] mysql database design

[Morris Dovey]

Dave J. Hala Jr. wrote:
| I'm working on a database design for storing and retrieving
| demographic information. The server is Mysql 4.x
| 
| Basically, I have a "root" table with a primary key and ten tables
| with records (10,000 of them) that are related to the root table
| via the primary key.  Inserting the data is at the moment a
| non-issue. However, retrieval is. Generally speaking I do not do
| joins across more then 3 tables.  In this instance it could be
| helpful to do a join across more than 3.
| 
| My concern is performance. Has anyone been in this situation
| before? How did your database design get around this issue?

Dave...

How long is your primary key?

Morris Dovey
DeSoto Solar
DeSoto, Iowa USA
http://www.iedu.com/DeSoto/