Best regards
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

I don't agree with you. You should post the code example which you used for tests (including HTML code and the included JavaScripts) and write which web browsers and in which versions you used. Do you used gridview:true parameter for example? Moreover in all realistic examples I see no sense to show the user 1000 or 10k rows at once. Moreover if you use SQL Server database you can implement grouping of data of the server side instead of doing it on the client side.

Regards
Oleg

Does anyone have similar experience? Is this expected? Is there any optimization I can do to improve performance? I'm currently using ajax to load the grid from a Sql Server database. I would like to implement subgrids as well. We're looking to be able to load at least around 10k rows at a time. Paging is not an option because we want the user to be able to compare data using grouping and summary rows.

Thanks,

Ben