title: what is the best way to implement pagination using spring MVC with mysql
body: <p>In my database I am having more than 100,000 records and it could be more in future. So I want to implement pagination for this.Its like posts and once in a while user can go to the oldest or too old posts. I am using spring MVC and database is mysql.</p>
  
  <p>Also I am using PagedListHolder to implement pagination. I want to display 25 posts per page but if I fetch all the 100,000 posts initially then it takes some time to load all the records. So is this better if I first load 100 records and then subsequently merge the list with another 100 records and so on. And if the user want to see the oldest post then fetch the   last 100 posts and display last 25 posts on last page.</p>
  
  <p>So just wanted to know is this solution feasible will this work if someone can help me to give the right direction. </p>