Can anyone suggest me the solution for the below problem.
I want to display 15 records in my grid each time.
When ever I want to retrive some records from the database and display in the grid I am having two problems.
1. When I try to retrive all the records at once and keep it in the Grid using load once property the grid hangs on if the record count is more than 10000.
2. If I use server side pagnation. Its difficult to hit the database so many times to revrive 10/15 records. Its more costlier.
At last I come up with a solution. If there are 10000 records to display I want to retrive 1000 records each time when I hit the database and keep in the Grid to display 15 records each time. After that next 1000 records and so on till 10000 records. So that I can avoid both the concerns mentioned above. How this can be possible using Struts2-Jquery Grid.