Bookmark Topic Watch Topic
  • New Topic

First/Previous/Next/Last Page

 
Yi Si
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Author and ninkuma
Marshal
Posts: 65667
129
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
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 ]
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!