jQuery Grid Plugin - jqGrid - Topic: jqGrid Performance http://www.trirand.com/blog/?page_id=393/help/jqgrid-performance-1 Simple:Press Version 5.7.5.3 costeen on jqGrid Performance http://www.trirand.com/blog/?page_id=393/help/jqgrid-performance-1#p30782 Help http://www.trirand.com/blog/?page_id=393/help/jqgrid-performance-1#p30782 I'm using jqGrid 4.6.0.  I tested in both both IE8 and IE11.  It seemed about the same.  I took columns from 30 to 15.  15 columns and 1000 rows in IE8 is taking around 4.2 seconds.  15 columns and 500 rows is taking about 2.2 seconds.  I probably have some flexibility with business requirements on the page size, but reducing the number of columns will be a harder sell.

]]> Thu, 19 Jun 2014 20:32:21 +0300 tony on jqGrid Performance http://www.trirand.com/blog/?page_id=393/help/jqgrid-performance-1#p30778 Help http://www.trirand.com/blog/?page_id=393/help/jqgrid-performance-1#p30778 Hello,

Which version of jqGrid is used? Which version of IE is slow?
Try to remove the frozen columns and see the result.
The number of rows is not a problem - the number the columns is a problem in IE.

If you reduce the columns to 15 what is the result?

Kind Regards

]]> Thu, 19 Jun 2014 11:56:51 +0300 costeen on jqGrid Performance http://www.trirand.com/blog/?page_id=393/help/jqgrid-performance-1#p30776 Help http://www.trirand.com/blog/?page_id=393/help/jqgrid-performance-1#p30776 Looking to see if anyone had ideas about making jqGrid perform better with larger datasets.  I have around 1000 rows and 30 columns.  It takes over 6 seconds to display the grid (not including retrieving the data) in Internet Explorer.  Chrome is slow too, but IE is by far the worse.  Using a small page size makes it perform better, but this is not acceptable to my users.  Has anyone else solved this?  I must use frozen columns as well.

<!DOCTYPE html>
<head>

<link rel="stylesheet" type="text/css" media="screen" href="./jqgrid/4.6.0/css/ui.jqgrid.css" />
<link rel="stylesheet" type="text/css" media="screen" href="./jquery-ui/1.9.2/css/smoothness/jquery-ui-1.9.2.custom.css" />
<script type="text/javascript" src="./jquery/1.9.1/jquery-1.9.1.js"></script>
<script type="text/javascript" src="./jquery-ui/1.9.2/js/jquery-ui-1.9.2.custom.js"></script>

<!-- jqgrid -->
<script src="./jqgrid/4.6.0/js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="./jqgrid/4.6.0/js/jquery.jqGrid.js" type="text/javascript"></script>
<script type="text/javascript" src="./js/data.js"></script>
<style>

html,body {
 height: 100%;
 overflow: hidden;
}

.ui-jqgrid .ui-pg-input {
 height:inherit;
}
</style>
</head>
<body>
 <label for="pages">Pages:</label><input id="pages" type="number" min="1" max="10" step="1" value="1" name="pages"/>
 <table id="gridTableId">
 </table>
 <div id="pager"></div>
</body>

<script type="text/javascript">

 var columns =
   [
     {
      "label" : "columnDataA",
      "id" : "columnDataA",
      "name" : "columnDataA",
      "classes" : "columnDataA",
      "frozen" : true,
      "width" : 143,
      "title" : true
     },
     
// .... columns deleted for brevity...

     {
      "label" : "columnDataEE",
      "id" : "columnDataEE",
      "name" : "columnDataEE",
      "classes" : "columnDataEE",
      "frozen" : false,
      "width" : 129,
      "title" : true
     } ];

 var creategrid =  function () {
  var start = now();
  $("table").jqGrid({
   datatype : 'clientSide',
   loadui : "disable",
   data : data,
   colModel : columns,
   reload : false,
   scroll : false,
   sortable : false,
   gridview : true,
   shrinkToFit : false,
   loadonce : true,
   rowNum : data.length/getPages(),
   width : $(window).width()-30,
   altRows : true,
   headertitles : true,
   altclass : "odd",
   pager: "#pager",
   pgbuttons: true,
   height : $(window).height()-100
  });

  $("table").jqGrid('setFrozenColumns');
 };
 
 $(document).ready(function() {
  creategrid();
 });

 var getPages = function () {
  var value = $("#pages").val();
  
  if($.isNumeric(value)) {
   return value;
  }
  
  return 1;
  
 };
 
</script>

</html>

]]> Wed, 18 Jun 2014 20:20:07 +0300