Could you please describe a bit more the scenario in which you observe this slowness? In case there is a big record set with not many matches in columns and rows, this slowness is expected, as this results in creating a quite large pivotized table. Our tests show that the PivotGrid can handle 10 000 columns with 10 rows ~ 100 000 cells for 10 seconds. On the server side these cells have corresponding objects which are generated for ~ 2 second, so the other 8 seconds goes to the browsers rendering engines. This test is performed on IE7, which cannot render such a big table fast. In modern browsers the results are better.
However I suggest you the following performance optimizations:
- Enable the paging
- this will decrease the number of items loaded at once
- Set the width of the columns, e.g.
In case the issue persists could please start a formal support ticket and send a runnable project, so we can replicate the issue on our side.
DevCraft Q1'14 is here! Watch the online conference to see how this release solves your top-5 .NET challenges. Watch on demand now.