jQuery Grid Plugin - jqGridForum

Topic RSS

[HELP] About selected row and populate a large data

10/12/2010
08:35

zenixgrace

Jakarta

Member

Members

Forum Posts: 41

Member Since:
10/05/2010

Offline

hiiii...,,

i use a a jqgrid as my grid

my configuration is like that :

$('#grdMain').jqGrid({
   datatype: "xml",
   colNames:['No.','GL Date','Invoice Date','Invoice No.','Customer Name','Ref','Customer Type','Product Name','Issue By','Sales Gross OC','Sales Net OC','Buying OC','Profit OC','Profit (%)','Plan Save OC','Discount OC'],
   colModel:[
       {name:'lineno',index:'lineno', width:75, key: true, sortable: false},
       {name:'inv_gl_date',index:'inv_gl_date', width:150, sortable: false},
       {name:'inv_date',index:'inv_date', width:200, sortable: false},
       {name:'inv_code',index:'inv_code', width:200, sortable: false},
       //{name:'inv_tick_date',index:'inv_tick_date', width:180, sortable: false},
       //{name:'inv_tick_no',index:'inv_tick_no', width:180, sortable: false},
       //{name:'inv_pax_name',index:'inv_pax_name', width:180, sortable: false},
       {name:'inv_cust_name',index:'inv_cust_name', width:180, sortable: false},
       {name:'invh_ref_invh',index:'invh_ref_invh', width:180, sortable: false},
       {name:'inv_cust_type_name',index:'inv_cust_type_name', width:180, sortable: false},
       {name:'inv_prodt_name',index:'inv_prodt_name', width:180, sortable: false},
       {name:'inv_issue_code_name',index:'inv_issue_code_name', width:180, sortable: false},
       /*{name:'inv_sls_oc',index:'inv_sls_oc', width:100, sortable: false, align:"right"},
       {name:'inv_sls_net_oc',index:'inv_sls_net_oc', width:100, sortable: false, align:"right"},
       {name:'inv_lg_oc',index:'inv_lg_oc', width:100, sortable: false, align:"right"},
       {name:'inv_profit_oc',index:'inv_profit_oc', width:100, sortable: false, align:"right"},
       {name:'inv_profit_p',index:'inv_profit_p', width:100, sortable: false, align:"right"},
       {name:'inv_ps_oc',index:'inv_ps_oc', width:100, sortable: false, align:"right"},
       {name:'inv_disc_oc',index:'inv_disc_oc', width:100, sortable: false, align:"right"}*/
       {name:'inv_sls_oc',index:'inv_sls_oc', width:100, sortable: false, align:"right",formatter:'integer',formatoptions:{thousandsSeparator:","}},
       {name:'inv_sls_net_oc',index:'inv_sls_net_oc', width:100, sortable: false, align:"right",formatter:'integer',formatoptions:{thousandsSeparator:","}},
       {name:'inv_lg_oc',index:'inv_lg_oc', width:100, sortable: false, align:"right",formatter:'integer',formatoptions:{thousandsSeparator:","}},
       {name:'inv_profit_oc',index:'inv_profit_oc', width:100, sortable: false, align:"right",formatter:'integer',formatoptions:{thousandsSeparator:","}},
       {name:'inv_profit_p',index:'inv_profit_p', width:100, sortable: false, align:"right",formatter:'integer',formatoptions:{thousandsSeparator:","}},
       {name:'inv_ps_oc',index:'inv_ps_oc', width:100, sortable: false, align:"right"},
       {name:'inv_disc_oc',index:'inv_disc_oc', width:100, sortable: false, align:"right",formatter:'integer',formatoptions:{thousandsSeparator:","}}
       //{name:'inv_ed_oc',index:'inv_ed_oc', width:100, sortable: false, align:"right",formatter:'integer',formatoptions:{thousandsSeparator:","}},
   ],
   /*loadError: function(xhr, st, str) {
       alert("Type: "+st+"; Response: "+ xhr.status + " "+xhr.statusText);
   },*/
   pager: false,
   width: 800,
   height: 150,
   rowNum: 1000,
   caption: "Report Sales"
});

i try to populate 1,000,000 rows in mygrid..

when i try to select a row by clicking it..

i got some problem at there..

it's to slow to change a colour row (yellow) where a click..

it's like have a delay...

and the other else...

i try to change my rownum to 4000 or -1..

i got my grid is to slow to give a feedback when i do some event (ex: scroll, click row, etc..)

how much max rownum i must set?

it's about a grid performance, isn't it?

CMIIW

best regards,

zenixgrace

10/12/2010
13:28

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

Sorry, but I am not sure do you write this seriously or you made a joke. I try to answer you in case that your question is not a joke.

Look at the following answer. I explain here how 1000 row can be quickly displayed in jqGrid. Removing of .ui-widget :active { outline: none; } from the jQuery UI and switching rows hovering with respect of hoverrows: false jqGrid parameter can improve the performance. Usage of JSON instead of XML and server side data compression (just a setting in practically all web servers) can also improve the performance.

The most important thing which you need understand is that the filling of jqGrid or other GUI element with a thousand, million or million of million rows has absolutely no sense. Look at the problem from the side of the user who look at his monitor. No monitor are able to show the information at once and no human able to read, analyse and understand so much information. Scrolling in the web browser is less effective and less user-friendly as paging in the jqGrid. So you have to use, sorting paging and user friendly filtering of the data. In case of million data items you should do this on the server side of cause.

Best regards
Oleg

11/12/2010
07:03

zenixgrace

Jakarta

Member

Members

Forum Posts: 41

Member Since:
10/05/2010

Offline

hii oleg..

many thanks for helping me, explain me and for the helpfull information..

i fixed that...

i'm wrote this seriously..

i try to populate a large data because i have 150 invoice in 1 day..

i try to build an web base application using php...

sorry for my english..

my english isn't good..

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
37 Guest(s)

Currently Browsing this Page:
1 Guest(s)