> I've been attempting to get my DB tuned to handle joins as best as
> possible. However, no matter which way I try to perform the joins, if I
> attempt to join more than two or three tables the joins becomes
> unbearably long not matter how many indexes I create in however many ways.
Ditto. Never saw a quadruple join succeed, even with relatively small tables.
> My only solution was to create a hybrid table that contains the join of
> all of the tables I'm searching on with multi-keyed indexes. This is a
> VERY kludgy solution that makes changing the keys to my DB hard to change.
The solution I use may be the worst imaginable kludge, but it works great: I do the joins (as well as other set
operations)on the client side. Perl hashes are very good for that.
--Gene