Received: from qmsql.netservers.net (hpmail1.netservers.net [209.196.128.163]) by postgresql.org (Postfix) with SMTP id 70A70475896 for ; Fri, 22 Feb 2002 10:18:14 -0500 (EST) Received: (qmail 24967 invoked from network); 22 Feb 2002 15:18:18 -0000 Received: from unknown (HELO AARON) (66.26.63.73) by hpmail1.netservers.net with SMTP; 22 Feb 2002 15:18:18 -0000 Message-ID: <01b101c1bbb3$8725dc30$110a010a@headquarters.wcgroup.com> From: "Samuel J. Sutjiono" To: Subject: Page Management Date: Fri, 22 Feb 2002 10:13:47 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01AE_01C1BB89.9DE7EAA0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200202/311 X-Sequence-Number: 6733 This is a multi-part message in MIME format. ------=_NextPart_000_01AE_01C1BB89.9DE7EAA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I have a question on page management. I want my web page to display the fir= st 10 rows (of 100 in the result set). If user clicks next page, it execut= es 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 ------=_NextPart_000_01AE_01C1BB89.9DE7EAA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
I have a question on page management. I wa= nt=20 my web page to display the fir= st 10=20 rows (of 100 in the result set).  If user clicks next page, it=20 executes the same SQL (in Stored Procedure) and displays records= =20 11-20.  What is the most effi= cient way=20 to accomplish this ?   Should I use LIMIT and OFFSET or Fetch fro= m=20 cursor ?
 
I appreciate any help.=
 
Regards,
Sam
------=_NextPart_000_01AE_01C1BB89.9DE7EAA0--