jQuery Grid Plugin - jqGrid

Oleg,

I did not use the gridview=true parameter because the documentation says that it's not allowed when using subgrids which we'd like to use to show detail rows for each total. I can probably get around that, and will try to implement in the next day or two to see if this flag will make a difference.

As far as the loading all the data on the grid, yes, we can do the aggregation in the back end, but our back end is already doing some heavy processing, and the idea was to get a control that will handle the grouping and summation on its own will all the results there. We understand there's a limit, but my expectation was that the limit would be in the 10k range and not the 1k range.

Here is the JS code for my app:

-----------------------------------------------------

grid.jqGrid(
      {
        datatype: function(pdata) {
          GetGridData(pdata);
        },
        //        grouping: true,
        //        groupingView: {
        //          groupField: ['Agent'],
        //          groupColumnShow: [true],
        //          groupText: ['Blah [<b>{0}</b>]'],
        //          groupCollapse: false,
        //          groupOrder: ['asc'],
        //          groupSummary: [false],
        //          groupDataSorted: true
        //        },
        colNames: columns,
        colModel: colModel,
        rowNum: 10,
        rowList: [10, 25, 50, 100],
        pager: jQuery("#GridPager"),
        sortname: "Agent",
        viewrecords: true,
        width: 705,
        height: 'auto',
        cellEdit: false,
        gridComplete: function() {
          alert("grid completed loading.");
        },

        subGrid: true,
        subGridRowExpanded: function(subgrid_id, row_id) {
          // we pass two parameters
          // subgrid_id is a id of the div tag created whitin a table data
          // the id of this elemenet is a combination of the "sg_" + id of the row
          // the row_id is the id of the row
          // If we wan to pass additinal parameters to the url we can use
          // a method getRowData(row_id) - which returns associative array in type name-value
          // here we can easy construct the flowing
          var subgrid_table_id, pager_id;
          subgrid_table_id = subgrid_id + "_t";
          pager_id = "p_" + subgrid_table_id;
          _SubGridToLoad = subgrid_table_id;
          $("#" + subgrid_id).html("<table id='" + subgrid_table_id + "' class='scroll'></table><div id='" + pager_id + "' class='scroll'></div>");
          jQuery("#" + subgrid_table_id).jqGrid({
            //url:"subgrid.php?q=2&id="+row_id,
            //datatype: "xml",
            datatype: function(pdata) {
              GetSubGridData(pdata);
            },
            colNames: columns,
            colModel: colModel,
            rowNum: 20,
            pager: pager_id,
            sortname: 'num',
            sortorder: "asc",
            height: '100%'
          });
          jQuery("#" + subgrid_table_id).jqGrid('navGrid', "#" + pager_id, { edit: false, add: false, del: false })
        },
        subGridRowColapsed: function(subgrid_id, row_id) {
          // this function is called before removing the data
          //var subgrid_table_id;
          //subgrid_table_id = subgrid_id+"_t";
          //jQuery("#"+subgrid_table_id).remove();
        }

-----------------------------------------------------

GetGridData() and GetSubGridData() are Ajax calls that return the records from our middle layer. Everything up to that point is pretty fast. The performance issues I'm having are on the grid itself, when sorting, etc. I'll let you know what my results are with the "gridview=true" setting.

Thanks,

Ben