jQuery Grid Plugin - jqGridForum

Topic RSS

How to increase the performance of jgGrid to populate more than 1000 rows

03/12/2010
13:52

Member

Members

Forum Posts: 4

Member Since:
02/12/2010

Offline

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.

03/12/2010
14:10

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

I suppose that without the code example of your JavaScript code, full HTML code with the list of all JavaScript files which you load, information about versions which you use (versions of jqGrid, jQuery, jQuery UI and so on) and the test data (in JSON or XML format) nobody are able to help you. Only after having this information one can give you some tips for the performance improvement.

Moreover I am sure that your real requirement is a little other. No person can really able to read 1000 rows of the multi-column contain at ones. No monitor can show the 1000 rows at once, so the scrolling of data will be done either by the web browser or by jqGrid itself. So the usage of at least client side data paging can be used without changing of your requirements. Moreover the usage of client side data filtering for example with respact of Toolbar Searching or/and Advanced Searching could be really helpful for the users who will have to examine 1000 rows of data.

Best regards
Oleg

06/12/2010
07:23

Member

Members

Forum Posts: 4

Member Since:
02/12/2010

Offline

Hi Oleg,

We are using jqGrid 3.6.4 and jquery 1.4.2 version. We are also using JSON datatype for displaying data in jqGrid. Following is the code snippet:

jQuery("#displayItemPerformanceGrid").jqGrid({
  url:'/DISMGMT/StandardProxy/displayItemPerformanceService?userRole='+userRole+'&userName='+userName+'&duration='+displayDuration+'&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 $"],
  colModel: [{
    name: "cmName",
    index: "cmName",
    classes: "metric",
    width: 130,
    resizable: true,
    align: "left"
   },
   {
    name: "displayLocation",
    index: "displayLocation",
    width: 80,
    align: "left"
   },
   ...
   ...
   ...
   }],
  width: 982,
  height: 137,
  toolbar: [true, "top"],
  viewrecords: true,
  rowNum: 1500,
  gridview:true,
  loadonce:true
});

In the preceding code snippet, when the URL goes to the server and get more then 1000 rows. Our business logic convert these 1000 rows in JSON format. Once all processes have been completed (retrive data from database and convert these data in JSON format), the control is transferred to jqGrid to pupoulate 1000 rows (in JSON format) in HTML page. Following is the code snippet of HTML page:
      <div id="displayItemPerformanceDiv" style="padding:0;margin:0;width:980px;height:200px;display: none;">
       <table id="displayItemPerformanceGrid" ></table>
      </div>

After the control is transferred to jqGrid to pouplate 1000 rows in HTML page, the jqGrid takes more than 20 seconds to populate data. Please, suggest me what can I do to increase the performance of jqGrid regarding for data population.

Note: Scrolling of data is maintained by jqGrid.

Thanks,
DM

06/12/2010
13:53

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

Sorry dm,

but the information which you posted is not sufficient to make any tests. I am enable reproduce your problem based on the information. You should prepare full example and not post only the definition of one column, some of jqGrid parameters and no test data. Till now I don't know which version of jQuery UI you use. Moreover I recommend you to use more recent version of the jQuery which has some performance enhancements. Till now you don't wrote also in which web browser (and which version) you made your tests.

To show you which can be performance of jqGrid with 1000 rows you can look at the following two example: one without paging and another used local paging. Is performance of this grids better as with your grid? I recommend you look also in the following post.

Best regards
Oleg

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
22 Guest(s)

Currently Browsing this Page:
1 Guest(s)