jqGrid's addRowData hangs for large number of records

Question

jqGrid's addRowData(idColumnName, array, direction, position) takes an array of rows and inserts them into the current page of the grid, ignoring any pagination settings. So if an array contains 3,000 rows, all 3,000 rows are inserted into the current page.

That throws an "unresponsive script" error in most browsers.

What "tricks" can one use to insert a very large number of rows (i.e. 3,000) into jqGrid at a specific position and have it respect pagination settings?

Why not use paging? so you don't have to pull so many rows at once? — wirey00, Sep 24 '12 at 21:00
These rows are generated on the client, not the server, so server-side pagination is not possible. — Donald T, Sep 24 '12 at 21:04

score 3 · Accepted Answer · edited May 23 '17 at 11:48

The usage of addRowData to update (or to add) large number of pages is the wrong way. jqGrid use internal data and _index options to hold the local data (see here, here and here for example). So you can get the reference to internal data parameter with respect of getGridParam. Then you can update the array in any way. You should additionally place the indexes of new added rows in _index or alternatively to call refreshIndex (see here for a code example) which rebuild the _index. In the last case you have to have full data source (data) which contains id property too. After all you should reload the grid (see here about the parameters of reloadGrid) to display updated grid.

Many thanks! I now update the "data" parameter and reloaded the grid. In that way, jqGrid respects pagination settings. — Donald T, Sep 27 '12 at 18:26

jqGrid's addRowData hangs for large number of records

1 Answers1