From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | Stuart Grimshaw <nospam(at)smgsystems(dot)co(dot)uk>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Why would this slow the query down so much? |
Date: | 2001-10-15 16:55:30 |
Message-ID: | web-147949@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Stuart,
> ------------------------------------------
> SELECT a.category, b.headline, b.added, c.friendlyname
> FROM caturljoin as a
> INNER JOIN stories as b ON (a.url = b.source)
> INNER JOIN urllist as c ON (a.url = d.urn)
> WHERE a.category = 93 ORDER BY b.added DESC LIMIT 1;
> ------------------------------------------
Hmmm? Where did table "d" come from? If this is really your query,
that's your problem.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Szabo Zoltan | 2001-10-15 19:41:10 | index problem |
Previous Message | Aasmund Midttun Godal | 2001-10-15 16:06:11 | Re: problem w/plpgsql proc |