Handling the functionality of Pivot Grid from server side

2 posts, 0 answers
  1. Mounika
    Mounika avatar
    4 posts
    Member since:
    Apr 2016

    Posted 10 May Link to this post

    Hi All,

    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

  2. Georgi Krustev
    Georgi Krustev avatar
    3688 posts

    Posted 12 May Link to this post

    Hello Mounika,

    The built-in cube generation functionality works only on the client-side. The limitation is not strongly defined and depends on many factors. I would suggest you check this help topic for more details. If you would like to use server-side implementation, then you will need to find a 3rd party one.

    In general, for such amount of data I would suggest you build the data on the server using either MS SSAS or other server solution. The requirement for the service is to support XMLA protocol as this is what the PivotGrid understands.

    Georgi Krustev
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Back to Top