[Cialug] mysql database design

[Dave J. Hala Jr.]

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