JSP pagination

Question

I have a query with over 3000 rows. I used an iterator to repeat each entry. Therefore, I have to reduce the system load, and I believe that the best way is to use pagination in jsp. If anyone has a better idea, I would be happy to hear that. something like a sample number or something like that. Presentation technology is the rack. If you think pagination is good, please help me.

Answer 1

Paging a result set in jsp solved the problem

Answer 2

To request a database with a limit, I mean putting a restriction in the query, for example, 0 to 50 on the first page. When requesting the first page, change your limit 0+(50*1) to 50+(50*1) , and for the nth page it will be like 0+(50*n) to 50+(50*n)

Answer 3

Pagination is a good idea. However, you must remember that you need not only to work, but you must also understand the purpose.

Implement pagination. But if you implement pagination, but still select the same number of lines, your goal will be defeated. You must improve your request . You should get the exact number of rows for the exact number of records that will be displayed on one page paginated . This way, both your application server and the database server will benefit from your implementation.