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..

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 

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