Greetings, please, before respond to the pagination of the grid, read what I'm looking for, it is not the normal pagination.

I have a table in my database with more than 10.000 registers, when I load the data into the grid, the page load turns very slow. If I load the entire data (more than 10.000 of registers) and I use “pager” and “rowNum”, fine, the grid page the rows.

But what I want to do is load from 30 to 30 rows, but I dont want to load the entire rows (the 10.000) once. I was using the event “onPaging” and I send to the server “rowNum”, “page”, “sortname” and “sortorder”, using the function ” jqGrid('getGridParam', “page”) “. I receive the parameters in the server and execute the sql that returns the “rowNum” of registers, depends of the page.

The problem is that in the load of the grid, I load just 30 rows, because rowNum=30 and page=0, so the sql give me the 30 first registers. it is good because load fast, but the pager doesnt work, becuase I'm loading just 30 registers, instead of the 10.000.

So, my question is,