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.