title: How to improve performance of jqGrid
body: <p>I have more than 1000 rows to populate data through jqGrid. When I populate data through jqGrid, jqGrid takes more than 20 seconds to populate data. This time is taken only by jqGird (query execution time and other time is excluded). I have a requirement to populate 1000 rows by using jqGrid and I don't want to use Pagination. Please help me how to increase the performance of jgGrid.</p>
  
  <p>The versions we are using are:
  jgGrid: 3.6.4
  jQuery:1.4.2
  jQuery UI:1.7.2
  Browser: IE 7</p>
  
  <p>Following is the code:</p>
  
  <pre><code>jQuery("#displayItemPerformanceGrid").jqGrid({
      //datatype: displayItemPerformanceGridData, //json
      url:'/DISMGMT/StandardProxy/displayItemPerformanceService?userRole='+userRole+
          '&amp;userName='+userName+'&amp;duration='+displayDuration+'&amp;userId='+userId,
      datatype: 'json',
      colNames: ["CM","Display Location","Display Name","Item","Item Description",
                 "Store","DC","Date","Type","Promo Retail","Reg. Retail 50" "Units",
                 "Sales $", "Profit $"],
  //      $("#load_navGrid").html("Loading...").show();
      colModel: [
          {name:"cmName",index:"cmName",classes:"metric",width:130,resizable:true,
           align:"left"},
          {name:"displayLocation",index:"displayLocation",width:80,align: "left"},
          {name:"displayName",index:"displayName",width:225,align:"left"},
          {name:"item",index:"item",sorttype:"int",width:60,align:"left"},
          {name:"itemDescription",index:"itemDescription",width:230,align:"left"},
          {name:"store",index:"store",sorttype:"int",width: 70,align: "right"//,
           //unformat : spaceFormatter
           },
          {name: "dc", index: "dc", sorttype: "int",width: 60,align: "right"//,
           //unformat : spaceFormatter
           },
          {name:"date",index:"date",sorttype:"date",datefmt:"mm-dd-yy",width:80,
           align: "left"},
          {name: "type",index: "type",width: 45,align: "left"},
          {name: "price",index: "price",width: 70,align: "left"},
          {name: "regRetail",index: "regRetail",width: 70,align: "left"},
          {name:"units",index:"units",sorttype:"int",width:45,align:"right",
           unformat : spaceFormatter},
          {name:"sales",index:"sales",sorttype:"int",width:45,align:"right",
           unformat : spaceFormatter},
          {name:"profit1",index:"profit1",sorttype:"int",width:40,align:"right",
           unformat : spaceFormatter}
      ],
      width: 982,
      height: 137,
      toolbar: [true, "top"],
      viewrecords: true,
      rowNum: 1500,
  //      gridview:true,
      loadonce:true
  });
  </code></pre>
  
  <p>Please suggest me how to improve performance of jqGrid</p>