jQuery Grid Plugin - jqGrid

Bump.  How can I use 'addRowData' to load all the rows at once? Anyone have an example?

Thanks.

Thank you for the reply Tony.I was able to fix this problem.

200-300 records load just fine. It starts to hit the tiomeout

depending on the user after about 1,500 records.

I finally figured out how to add the records all at once as you suggested. This did help

quite a bit, with about a 30% increase in performance. Unfortunately the timeout was

still being triggered on some machines. And since there could be 4,000+ records at

some points, that wouldn't work for me.

So what I did was instead of sending down 1 large javascript call, I broke each row addition

into its own javascript call and then flushed the browser cache. This way each call is only a fraction

of a second and the timeout will never be triggered even if you loaded 50,000 rows. This is

the relevent code:

                jQuery("#myTable").jqGrid({
                        datatype: "local",
                        colNames:['Select','State Number 1', 'State Number 2', 'eHars StNo 1','eHars StNo 2','Match Weight'],
                        colModel:[
                                  {name:'Select',index:'Select',sortable:false},
                                  {name:'StateNumber1',index:'StateNumber1'},
                                  {name:'StateNumber2',index:'StateNumber2'},
                                  {name:'eHarsStNo1',index:'eHarsStNo1'},
                                  {name:'eHarsStNo2',index:'eHarsStNo2'},
                                  {name:'MatchWeight',index:'MatchWeight'}
    
                               ],
                               height: "70%",
                               autowidth: true,
                               altClass: 'altRow',
                               altRows: true,
                               caption: "Click on the first State Number in the pairs of statenos below to combine"
                               });
                </script>

               while (rs.next() ){

        <script>
        jQuery("#myTable").jqGrid('addRowData',i,{Select:"<input type='radio' name='merge' onClick='goToMergeCheck()'><input type=hidden name=stateNo1 value='<%=stateNo1%>'><input type=hidden name=stateNo2 value='<%=stateNo2%>'",StateNumber1:"<%=stateNo1%>",StateNumber2:"<%=stateNo2%>",eHarsStNo1:"<%=eHarsNo1out%>",eHarsStNo2:"<%=eHarsNo2out%>",MatchWeight:"<%=HTML.formatForTD(matchKey)%>"});
        i++;    
        </script>

        <%out.flush();%>

}

This caused the table to visibly grow as it loaded. I prefer to only show the table when it is ready so I had

the table hidden and a javascript please wait animation shown while it was loaded. Then at the end of the page

I changed the table div to blocked. Works great and I tested with 9,000 records.

I want to mention a couple of things. A couple of the grid options destroy the loading performance.

with this option:    rownumbers: true;

or

  pager : '#gridpager',
pgbuttons: false,
 pginput: false,
viewrecords: true,
recordtext: "Total Records:&nbsp;&nbsp;<font style='color:red'>{2}</font>",

Will make the table load much, much slower. Without those options 3,000 records

will take about 14 seconds to load. With those options on it will take about 8 minutes.

In my case I just wanted the pager there to display the total number of records.

I removed number being loaded and just had a straight text string of "this is a test"

in there and it was still just as slow. Just wanted to give you a heads up.

Thanks for all your hard work on this. Now that I have the timeout issues resolved

my users are loving jqgrid.