Re: Why would this slow the query down so much?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Why would this slow the query down so much?
Дата
Msg-id web-147949@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Why would this slow the query down so much?  (Stuart Grimshaw <nospam@smgsystems.co.uk>)
Список 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
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: EXECUTE ... INTO?
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: VARCHAR vs TEXT