Forcing a specific order

Поиск
Список
Период
Сортировка
От Martin Foster
Тема Forcing a specific order
Дата
Msg-id 434C5F49.1010108@ethereal-realms.org
обсуждение исходный текст
Ответы Re: Forcing a specific order
Re: Forcing a specific order
Список pgsql-novice
This may come across as a rather odd question.   However, is there a way
to force PostgreSQL to return rows in a very specific order?  I am
currently facing running one three-way-join query which will last 50+
seconds.   Since this is a web-based application this hardly makes for a
fast browsing experience.

One solution is to break it up into more manageable pieces.   If I can
specify the sort order then I can run concurrent queries and get things
settled easily.   Otherwise I'll have to fetch for every row returned
and that seems messy and I would like to avoid it.

Any ideas?

    Martin Foster
    martin@ethereal-realms.org


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