Re: Paged Query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Misa Simic <misa.simic@xxxxxxxxx>
Subject: Re: Paged Query
From: Gregg Jaskiewicz <gryzman@xxxxxxxxx>
Date: Mon, 9 Jul 2012 12:55:33 +0100
Cc: Hermann Matthes <hermann.matthes@xxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <CAH3i69=B7VPj0rkbuxv9TLEF6V0DjB2xzcEUkf8U7BYULCOBug@mail.gmail.com>
References: <4FF43638.5080301@web.de> <CAH3i69=B7VPj0rkbuxv9TLEF6V0DjB2xzcEUkf8U7BYULCOBug@mail.gmail.com>

Use cursors.
By far the most flexible. offset/limit have their down sides.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Follow-Ups:
- Re: Paged Query
  - From: Misa Simic
- Re: Paged Query
  - From: Craig Ringer

References:
- Paged Query
  - From: Hermann Matthes
- Re: Paged Query
  - From: Misa Simic

Prev by Date: Re: Create tables performance
Next by Date: Re: Paged Query
Previous by thread: Re: Paged Query
Next by thread: Re: Paged Query
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux