I’ve got a sample table I’m using to build a proof of concept using jqGrid 4.6.0.  The sample table contains ~45M rows (the production tables will routinely be 800M-1B and could reach 5-6B rows).  I am dynamically loading 500 records at a time via JSON using a variation of the sample PHP script provided by your example.

I can see that there are 90,000+ pages, and the record count (1 to 500 of 45,000,000) shows correctly.  Unfortunately, I cannot page beyond 1,525,000-1,526,000 records no matter what I do.  I suspect this has something to do with the height of the DIVs in pixels generated by jqGrid.  In this case, when inspecting the element, I see a div with a height of 994357144px.  If I change scroll: 1 to scroll: false, it works just fine via pagination.

Is there some way to overcome this?  Has anyone else tested with 5M, 10M, 50M records and found success?  I really like jqGrid otherwise, but the scroll is a must.