jqgrid with large local data sets

Question

I'm looking for recommendations for jqgrid to add a large dataset from a local source. Right now, there's a simple loop:

grid.clearGridData();
for(var i = 0; i < data.length; i++)
{
    grid.addRowData(i+1, data[i]);
}
grid.trigger(”reloadGrid”);

And on some larger data sets, this causes the browser to display the “javascript is using too many resources…quit/continue” message in IE and FF, usually after several “Continues” everything is fine. This is for data sets of ~2000 rows.

I can break this up into several chunks with setTimeout, but that feels kludgy.

Using version 3.3 of jqgrid.

Answer 1

My first thought is that 2000 rows is usually far too many for a single page; users just won't be able to process that much information. If they do need it all at once for some reason, it might be worth exporting to CSV, since that usually makes it easier to do the sorts of things one would want to do on 2000 rows of data, e.g., arbitrary statistics.

My next thought is that if you still need to do this, you might try upgrading to the most recent version of jqGrid (currently 3.6.1) in the hopes that they've optimized this path a bit.

Another idea: if you're using JSON, have you tried configuring jqGrid to let the browser's native parsing handle parsing the JSON? It's documented here a little way down the page.

In general, setTimeout kludges are the way to fix this sort of thing if you really need it, but most of the time you're better off taking a step back and looking for a different solution to whatever problem you're solving.