Hi,
I am using the igTreeGrid in my application to display the records.Every thing works fine when i provide less number of records to the grid, but my requirement is to display around 40,000 records at a time. so when i provide these many records to the grid ,it is taking around 2mins of time which is very high. So what should i do to improve the performance atleast to half of the current time. I have looked at the "Virtualization" and "load on demand" ,I didn't get exactly what they are. When i use virtualization grid is taking more time than without the virtualization and may i know how load on demand works and how can i provide only some part of the data to the grid using load on demand when there is a parent child relation between the nodes.Here is the code which i have used, can any one help me out of this issue.
$("#treegrid").igTreeGrid({ dataSource: totalObjects, width: "100%", 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" } ]});
Hello Saikiran,
What is the server-side technology that you use to generate the data? It looks like igTreeGrid Load on Demand is the functionality to use, but the data is not applicable for this feature to work with (assuming you're not using igTreeGrid MVC Wrapper), so you'll have to manually handle the remote requests that igTreeGrid sends to the server (see the "Request Format" section in Load on Demand (igTreeGrid) topic) and return the correct data in the respective format.
Best regards,Martin PavlovInfragistics, Inc.
this is my data which is to be supplied to the treegrid
Hi Vasya,
i am unable to understand the code in ASP .NET ,can you send the solution in javascript as like of in ignite website or give an example with the same code which i have asked in my question.
Please unzip the attached sample and open igTreeGridManyRecords folder. In this folder there is a solution file named igTreeGridManyRecords.sln which you will have to double click in order to open the solution in Visual Studio.
Please let me know if you need any further assistance with this matter.
I am unable to run the application. Can you say which file(location of the file) i need to run and in which environment as i couldnt able to find any index.html .
Thank you,
Saikiran.