Page 1 of 1

CSHTML5 dataGrid huge performance issues

Posted: Thu Oct 06, 2016 1:25 am
by Sesztak
Dear JS-Support,

We have made some performance test with your CSHTML5 dataGrid and found huge performance issues/bottleneck related of CSHTML5 dataGrid.

(Server data sent by WCF basic http bindig to CSHTML5 clients, normal XML serialization).

Test enviroment / conditions:
-only 18 columns (some DataGridTextColumn, some DataGridTemplateColumn with custom simple DataTemplate -nothing special !)
-only 4 rows of data sent by Server, (serialized xml size: appx. 16 000 bytes only),
-Browser: Chrome v53.0.2785.143 m (latest)
-good ping and internet conditions between Server and Client.

Test results:
(all values are average of multiple measurements)
(stopWatch.Start() - Stop ())
1.) Server time needed to produce and send xml data to Client: 80 milliseconds.
2.) Total Client round up time from initiate and got data WITHOUT filling ItemsSource of CSHTML5 datagrid: 200 milliseconds
(note: ok, as expected)
3.) Total Client round up time from initiate and got data WITH filling ItemsSource of CSHTML5 datagrid:
First time: appx. 4000 milliseconds (huge performance issue!!)
Second, 3rd, etc. time: apprx. 2000 milliseconds (huge performance issue!!)

So, our questions:
Q1: Is it and expected performance of CSHTML5 datagrid or a kind of bug ?
Q2: Can you recommend any other open source datagrid with similar functionality as present CSHTML5 datagrid ?
(e.g. no row virtualization needed as we handle it at server side, no row reordering needed, the only requirement to put some text- and checkboxes and stackPanels, and get reference to certain cell)

Thanks for your kind reply,
Best Regards,
Péter

Re: CSHTML5 dataGrid huge performance issues

Posted: Mon Oct 10, 2016 2:29 am
by JS-Support @Userware
Hi Péter,

Thanks for your message.

Yes, we are aware of the current DataGrid performance issues and we are working on them. You can expect some improvements in the coming weeks. Beta 10.1 has already started to improve performance, though only marginally for the moment (8%).

Alternatively, you can use a JS-based DataGrid library, such as that from Telerik Kendo UI or another JS components provider. You can easily include it in your CSHTML5 application via Interop calls. For other people who may be new to interop, this is the reference:
http://cshtml5.com/links/how-to-call-javascript.aspx

Thanks.
Regards,
JS-Support

Re: CSHTML5 dataGrid huge performance issues

Posted: Mon Oct 10, 2016 2:33 am
by Sesztak
Hi JS-Support,
Thanks for your straightforward words, it helps to clarify next steps/make decisions.

Thanks again,
Br,
Péter

Re: CSHTML5 dataGrid huge performance issues

Posted: Mon Oct 10, 2016 2:41 am
by Sesztak
Hi JS-Support,

For your kind information: we tried to implement a kind of quasi datagrid:
ListBox + DataTemplate,

the result (with exactly the same complexity of grid as mentioned at datagrid):
-first time: apprx. 2000 millisec,
-all other later: around 800 -1200 millisec.

So, we should say: it getting better (half of of datagrid time values) but far away from expected.
It's seem like the performance bottle neck source should be :
your
-DataTemplate
or
-ItemSource
handling / implementation problem.

Br,
Péter

Re: CSHTML5 dataGrid huge performance issues

Posted: Mon Oct 10, 2016 2:52 am
by JS-Support @Userware
Thanks Péter for the additional information.

Indeed, our current focus to improve performance includes those areas.

Regards,
JS-Support