| From: | Wei Weng <wweng(at)kencast(dot)com> |
|---|---|
| To: | "Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Page Management |
| Date: | 2002-02-22 15:58:07 |
| Message-ID: | 3C766A8F.4020505@kencast.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Mello | 2002-02-22 16:00:19 | Re: comparision chart |
| Previous Message | Roberto Mello | 2002-02-22 15:55:16 | Re: Postgres vs. Mysql |