[Cialug] mysql database design

[David Champion]

It's not that bad, if you write your joins logically, using explicit
JOIN instead of just joining in the WHERE.

I'm just curious as to how you've come up with a situation where you
_have_ to join 10 tables.

-dc

Dave J. Hala Jr. wrote:
> I'm gonna give the massive join a try here sometime in the next couple
> of days. However, thinking about and running a sql statement for a
> 8-9-10 table join just makes my butt cheeks clench. We'll see how it
> goes.
> 
> :) Dave
> 
> On Thu, 2007-08-09 at 09:57 -0500, Morris Dovey wrote:
>> Dave J. Hala Jr. wrote:
>> | 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?
>>
>> In a couple of the systems I've worked on we implemented trie indexes
>> for _extremely_ fast retrieval. In one case the trie was used in
>> parallel with the indexing provided in a canned db package, and in the
>> others it was the only index used.
>>
>> If you're not familiar with the trie, you can probably find good info
>> via Google. It provides very fast retrieval, but only so-so insertion
>> speed.
>>
>> 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
> 
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>