[Cialug] mysql database design

[Dave J. Hala Jr.]

The primary key is an integer.


On Thu, 2007-08-09 at 09:33 -0500, Morris Dovey 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...
> 
> How long is your primary key?
> 
> Morris Dovey
> DeSoto Solar
> DeSoto, Iowa USA
> http://www.iedu.com/DeSoto/
> 
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug