Re: Simple join optimized badly?

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Simple join optimized badly?
Дата
Msg-id 20061010140702.GB72517@nasby.net
обсуждение исходный текст
Ответ на Re: Simple join optimized badly?  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Simple join optimized badly?  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Re: Simple join optimized badly?  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-performance
On Mon, Oct 09, 2006 at 08:22:39PM -0700, Joshua D. Drake wrote:
>
> > Imagine I got run over by a train, and someone was reading my code.
> > Which would be easier for them to maintain: Code with weird SQL, or code
> > with sensible, well-written SQL and explicit hints?
>
> You forgot the most important option:
>
> Code with appropriate documentation about your weird SQL.
>
> If you document your code, your argument is moot.

You apparently didn't read the whole email. He said he did document his
code. But his point is still valid: obscure code is bad even with
documentation. Would you put something from the obfuscated C contest
into production with comments describing what it does, or would you just
write the code cleanly to begin with?
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Simple join optimized badly?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Simple join optimized badly?