Re: cursor MOVE vs OFFSET in SELECT
От | Grzegorz Jaśkiewicz |
---|---|
Тема | Re: cursor MOVE vs OFFSET in SELECT |
Дата | |
Msg-id | 2f4958ff0910260334r2bec490cq6f0181fb317fdc36@mail.gmail.com обсуждение исходный текст |
Ответ на | cursor MOVE vs OFFSET in SELECT (silly8888 <silly8888@gmail.com>) |
Ответы |
Re: cursor MOVE vs OFFSET in SELECT
Re: cursor MOVE vs OFFSET in SELECT |
Список | pgsql-general |
On Mon, Oct 26, 2009 at 10:30 AM, silly8888 <silly8888@gmail.com> wrote:
OFFSET/LIMIT. Afaik cursor always fetches everything.
Suppose that you have a query, say $sql_query, which is very
complicated and produces many rows. Which of the following is going to
be faser:
$sql_query OFFSET 3000 LIMIT 12;
or
BEGIN;
DECLARE cur1 CURSOR FOR $sql_query;
MOVE 3000 IN cur1;
FETCH 12 FROM cur1;
COMMIT;
Naturally, the former cannot be slower than the latter. So my question
essentially is whether the MOVE operation on a cursor is
(significantly) slower that a OFFSET on the SELECT.
OFFSET/LIMIT. Afaik cursor always fetches everything.
--
GJ
В списке pgsql-general по дате отправления: