First/Previous/Next/Last Page

[Yi Si]

Hello there,
Problem:
I want to implement "First/Previous/Next/Last Page" function for data retrive.
I think there are three strategies for this.
1. Download all records in client, control them with JS.
2. Retrive data again from DB every time of turning page.
3. Retrive all records one time, then cache them in server memory to response client retrieve.
Question:
Can somebody tell me which is best practise?
Whith second strategy, I think I need add mark on DB.
How to do this?

[Bear Bibeault]

Please do not cross-post in multiple forums. Please continue any discussion here.
thanks,
bear
JDBC Forum Bartender
[ March 09, 2004: Message edited by: Bear Bibeault ]