Comments by Diya khan (Top 4 by date)

what is the error?

First, if you want to get records from server according to your page-size then you have to implement that logic on server-end. If server is returning all records at once then performance cannot be increased at client side.

Second, you have set datatype parameter to local which means that all paging,sorting and filters should work with local data (that have been stored at a first time load).

If you use loadonce:true jqGrid change the datatype parameters to 'local' after the first load of data from the grid. All next grid reloading (sorting, paging, filtering) works local. If you want refresh the grid data from the server one you should set loadonce:false and datatype to its original value ('json' or 'xml'). For example:

$("#list").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');

So in case of loadonce:false or no loadonce parameter your server is responsible for sorting and paging of the data. If it is not work you have to verify your server code.