From: | "Gene Selkov Jr(dot)" <selkovjr(at)mcs(dot)anl(dot)gov> |
---|---|
To: | pierre <pierre(at)desertmoon(dot)com>, pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Joining bug???? |
Date: | 1998-10-27 03:18:25 |
Message-ID: | 199810270417.WAA27985@antares.mcs.anl.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | pierre | 1998-10-27 03:39:44 | Joining bug???? |
Previous Message | Brenda Butler | 1998-10-27 02:16:49 |