We have a requirement to show json data as a pivot grid.
We have to fetch with a large amount of data from an SQL DB (about 40.000 to 1.000.000 rows). We are having a service which would return this data as json object.
We need to show this data as a pivot grid restitution in our app, and apparently, that kind of component would suits our needs.
As we have a lot of data :
- Is this possible at Server-side instead client side?
If this is not possible at server side then what is the max capacity that pivot grid can handle with best performance?
Below is the sample fiddle:
Thanks in Advance