[Cialug] mysql database design

[Dave J. Hala Jr.]

I'm running mysql 4.x  on RHEL 4.x, while its not 5 on 5, I think its
new enough.

On Thu, 2007-08-09 at 09:35 -0500, David Champion wrote:
> 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
> 
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug