How to do pagination which reduce our server load ?
Hello friends
I want to do pagination using java.
There are two ways comes in my mind to do pagination.
1.Fetch whole data at once and display it page by page.
2.Fire the query when people hit for the new page.
I think in 1st case server load is more while in other case it's not.But i don't have any idea how to implement this.
Suppose i have 100's of record's are stored in my database.I want to fetch 2nd 10 data after clicking on the 2nd page and 3rd 10 data on the click of 3rd page.So anybody know the sql query to do so ?
Please suggest some tld file which can help in doing this work.
I want to do pagination using java.
There are two ways comes in my mind to do pagination.
1.Fetch whole data at once and display it page by page.
2.Fire the query when people hit for the new page.
I think in 1st case server load is more while in other case it's not.But i don't have any idea how to implement this.
Suppose i have 100's of record's are stored in my database.I want to fetch 2nd 10 data after clicking on the 2nd page and 3rd 10 data on the click of 3rd page.So anybody know the sql query to do so ?
Please suggest some tld file which can help in doing this work.
0