jQuery UI Widgets › Forums › DataTable › Performance AddRow
Tagged: angular datatable, angular2 datatable, bootstrap datatable, javascript datatable, jquery datatable, jqwidgets datatable, jqxdatatable, typescript datatable
This topic contains 4 replies, has 2 voices, and was last updated by Hristo 8 years, 3 months ago.
I have an datatable with a pageSize of 10 und 3 columns.
When I perform a search in my webapplication it is performed on servererside an the results are added to my datatable. Therefore I invoke addRow in a for – loop.
When I only get a few results (1000 and lower) everything is fine.
When I get 10.000 results it takes about 2 Minutes to fill the datatable.
On the same webapplication I have an treeGrid. This treeGrid is also filled inside a forloop with the searchresults with addRow. When I get 10.000 results it takes less the 5 seconds.
Is there a way to speed up the datatable or is it a bug? I also tried to use beginUpdate / endUpdate but with no success.
I created an example on JSFiddle, that shows the problem. There it only takes 30 seconds, but you can see, that time is rising.
Hello Matthias,
You try to add a new row in each iteration and this slowed the process.
Please, take a look at this example.
Also, will be better if you load data before initialized the DataTable.
Best Regards,
Hristo Hristov
jQWidgets team
http://www.jqwidgets.com
Thank you. I didn’t know that I can give an array to addRow.
Loading the data before initialization of the table isn’t possible in my case, because I initialize an empty table. And after userinteraction I get the items from server.
Hello Matthias,
You could use and this approach – change the source and updateBoundData method.
Please, take a look at this example:
http://jsfiddle.net/Lmxb0482/
Hope this help.
Best Regards,
Hristo Hristov
jQWidgets team
http://www.jqwidgets.com
You must be logged in to reply to this topic.
