From: Wei Weng <wweng@kencast.com>
To: Samuel J. Sutjiono <ssutjiono@wc-group.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Page Management
Date: Fri, 22 Feb 2002 10:58:07 -0500
Message-ID: <3C766A8F.4020505@kencast.com> (raw)
References: <01b101c1bbb3$8725dc30$110a010a@headquarters.wcgroup.com>
Sam:
I had done the same thing in a recent project using LIMIT keyword. The
performance was quite satisfactory.
Samuel J. Sutjiono wrote:
> Hello,
>
>
>
> I have a question on page management. I want my web page to display the
> first 10 rows (of 100 in the result set). If user clicks next page, it
> executes the same SQL (in Stored Procedure) and displays records 11-20.
> What is the most efficient way to accomplish this ? Should I use LIMIT
> and OFFSET or Fetch from cursor ?
>
>
>
> I appreciate any help.
>
>
>
> Regards,
>
> Sam
>
--
Wei Weng
Network Software Engineer
KenCast Inc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: wweng@kencast.com, ssutjiono@wc-group.com
Subject: Re: Page Management
In-Reply-To: <3C766A8F.4020505@kencast.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox