Received: from mta1.snet.net (mta1.snet.net [204.60.203.70]) by postgresql.org (Postfix) with ESMTP id 5464E475A86 for ; Fri, 22 Feb 2002 10:50:28 -0500 (EST) Received: from pop.snet.net ([204.60.203.73]) by mta1.snet.net (8.12.1/8.12.1/SNET-smtp-1.1/D-1.1/O-1.1) with ESMTP id g1MFn50G012728; Fri, 22 Feb 2002 10:49:06 -0500 (EST) Received: from kencast.com (167.95.252.64.snet.net [64.252.95.167]) by pop.snet.net (8.12.1/8.12.1/SNET-pop-1.2/D-1.2/O-1.3) with ESMTP id g1MFoNre027326; Fri, 22 Feb 2002 10:50:25 -0500 (EST) Message-ID: <3C766A8F.4020505@kencast.com> Date: Fri, 22 Feb 2002 10:58:07 -0500 From: Wei Weng Reply-To: wweng@kencast.com User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.8) Gecko/20020205 X-Accept-Language: en-us MIME-Version: 1.0 To: "Samuel J. Sutjiono" Cc: pgsql-sql@postgresql.org Subject: Re: Page Management References: <01b101c1bbb3$8725dc30$110a010a@headquarters.wcgroup.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200202/314 X-Sequence-Number: 6736 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.