Re: Page Management

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.