[Cialug] mysql database design

[David Champion]

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

Shouldn't be a big issue - if you have the correct indexes (i.e. all of
your join expressions, order by etc should have an index on them).
10,000 records is pretty small.

This is assuming you're not running on an ancient version of RedHat or
something. MySQL 4 & 5 have had a lot of performance improvements.

-dc