We have a simple table with employee data containing a 100k records. We want to display them using pagination on a simple JSP page with helper class/bean.

On one page we'll display 50 records.

Shall I fetch 50 records as per the page number & display them/ Use some other alternative?

What should be the best design approach to this problem?