Query question

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Query question
Дата
Msg-id
3FB303E9.20903@familyhealth.com.au
Список
Дерево обсуждения
Query question Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Query question Josh Berkus <josh@agliodbs.com>
Re: Query question Neil Conway <neilc@samurai.com>
Re: Query question Tom Lane <tgl@sss.pgh.pa.us>
Re: Query question Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Hi,

I have coded some improvements to phpPgAdmin that I think are pretty 
cool.  Basicaly, once you are browsing the results of an arbitrary 
SELECT query, you can still sort by columns, regardless of the 
underlying ORDER BY of the SELECT.

I do this like this:

SELECT * FROM (arbitrary subquery) AS sub ORDER BY 1,3;

Now, this all works fine, but I want to know if this is efficient or not.

Does doing a select of a select cause serious performance degradation?

Chris


В списке pgsql-performance по дате отправления
От: Suchandra Thapa
Дата:
Сообщение: Re: performance optimzations
От: Rod Taylor
Дата:
Сообщение: Re: performance optimzations
FAQ