i using "infragistics igtreegrid" in application display records.every thing works fine when provide less number of records grid, requirement display around 40,000 records @ time. when provide these many records grid ,it taking around 2mins of time high. should improve performance atleast half of current time. have looked @ "virtualization" , "load on demand" ,i didn't are. when use virtualization grid taking more time without virtualization , may know how load on demand works , how can provide part of data grid using load on demand when there parent child relation between nodes.here code have used, can 1 me out of issue.
$("#treegrid").igtreegrid({ datasource: totalobjects, width: "100%", //roweditdialogheight: "100px", autogeneratecolumns: false, enabledeleterow: false, primarykey: "name", foreignkey: "parent", editmode: "cell", initialexpanddepth: 1, /* virtualization : true, virtualizationmode : "continuous", height : "400px",*/ columns: [ {headertext: "product hierarchy", key: "name", datatype: "string", readonly: "true"}, { headertext: "associated materials", key: "associations", width: "120px", datatype: "string", readonly: "true" }, {headertext: "level", key: "key", width: "50px", datatype: "string", readonly: "true"}, {headertext: "description", key: "excel_desc", datatype: "string", editable: "true"}, { headertext: "sap description", key: "sap_desc", datatype: "string", readonly: "true" //editortype: "text", //editoroptions: {textmode: "multiline",maxlength: 100} }, // { headertext: "", key: "source", datatype: "string", readonly:"true",hidden: true }, ], childdatakey: "children", initialexpanddepth: 0, features: [ { name: "responsive" }, { name: "resizing" }, { name: "paging", pagesize: 8, mode: 'alllevels' }, //filtering & sorting { name: "filtering", type: "local", mode: "simple", filterdialogcontainment: "window", columnsettings: [ { columnkey: "name", condition: "startswith" }, { columnkey: "associations", condition: "equals" }, { columnkey: "key", condition: "equals" }, { columnkey: "sap_desc", condition: "equals" }, ] }, { name: "sorting", type: "local" }, ] });
as provided in comments rendering time 35k rows foreign key relationship ~10 seconds.
to improve further either provide child objects child objects in data source, , not foreign key, reduce rendering time ~2 seconds, or use load on demand, load children each parent upon expansion of parent.
Comments
Post a Comment