1. Home
  2. Forum
  3. React - EJ 2
  4. Server side pagination

Server side pagination

Hi,

We're trying to optimize performance of the pivot view when large datasets are used (think millions of records per dataset).

Currently, we have activated virtual scrolling in our table and we also activated data compression. However, despite having all these options activated, the table still hangs while loading larger datasets (we're experiencing delays in loading datasets with 70 000 records).

Thus, we were hoping that there would be a way to implement server side pagination, which would allow us to define the page size and then subsequently retrieve pages with a smaller number of rows. This would make rendering easier, because the server would endure the heaviest part of the work and the table would receive the data from each page at once.

However, from what I understood from your documentation and also from the issues raised by other users of this and other components, the options we have enabled (virtual scrolling, data comprssion, and virtualization) are the only things you have available to try and expedite the loading. No server side pagination is provided.

Right now we load the entire dataset to the table and we let it do its job, but this will quickly make things unbearable when we load datasets with millions of lines of data.

Is there any way to implement server side pagination in pivot view?  Alternatively, is there an event being triggered when the table tries to load more data dynamically?

Thanks in advance.

8 Replies 1 reply marked as answer
SS Saranya Sivan Syncfusion Team May 7, 2021 01:00 PM UTC

Hi Oliveira, 
  
Thank you for using Syncfusion Products. 
 
The pivot table requires complete raw data to do the aggregation. So, binding page by page raw data to the component isn’t applicable. And is your problem to pass huge size of raw data to browser, then we have server side engine where the entire aggregation is performed in server and only the sliced information alone will be passed to client side. 
  
Meanwhile, we have prepared a stand-alone WebAPI sample to do the aggregation in server side and passed only the sliced aggregated details in client side. Please check the guidelines in the below file to run the controller application. 
  
  
  
Please let us know if you have concerns. 
  
Regards, 
Saranya S. 
  
 


MO M Oliveira May 19, 2021 09:39 AM UTC

Hi Saranya,

> Meanwhile, we have prepared a stand-alone WebAPI sample to do the aggregation in server side and passed only the sliced aggregated details in client side. 

This WebAPI you mentioned, is it connected to any server side solution by Syncfusion? If so, which are you using?

Best wishes,
M. Oliveira.

MM Manikandan Murugesan Syncfusion Team May 20, 2021 12:51 PM UTC

Hi Oliveira, 
 
We have “Syncfusion.EJ2.Pivot” library which we call as server side engine where the entire pivot calculations done and it return only the view-port information to the browser. And it is available in below link, 
 
 
In the below provided WebAPI application, we have used the above library. 
 
 
And the below pivot table sample connect with the above WebAPI application. Kindly refer the guidelines provided by above link. 
 
 
We hope the above will resolve the reported problem. 
 
Please let us know if you have any concerns. 
 
Regards, 
Manikandan 


Marked as answer
RS Raja suriya October 30, 2022 03:07 PM UTC

server side pagination is not working


AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team October 31, 2022 01:49 PM UTC

Hi Raja,


As we mentioned earlier, currently we don’t have pagination support in our server side engine. However, we recommend you to use the virtualization and data compression option to avoid performance problems while binding large amount of data in the pivot table. For more information about the virtualization and data compression features, please refer the UG document below.


Virtualization: https://ej2.syncfusion.com/react/documentation/pivotview/virtual-scrolling/#virtual-scrolling

Data Compression: https://ej2.syncfusion.com/react/documentation/pivotview/virtual-scrolling/#data-compression


However, we have prepared a server side sample with 1Million data. Please refer it from below link.


Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/server-side-pivot-engine-for-pivot-table-1936568350


Meanwhile, we are validating the possibilities to implement the pagination support in server side engine and we will update further details within two business days (Nov 2, 2022).


Regards,

Angelin Faith Sheeba.


AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team November 3, 2022 01:17 PM UTC

We have considered your requirement as a feature and logged a feature request “To provide paging support for server side engine”. And this support will be available in our 2023 Volume 1 SP release which is expected to be rolled out at May, 2023. You can track the feature status from the below feedback link.


Feedback Link : https://www.syncfusion.com/feedback/38852/to-provide-paging-support-for-server-side-engine


AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team March 24, 2023 04:34 PM UTC

Hi Oliveir,


We are glad to announce that our Essential Studio 2023 Volume 1 Main Release V21.1.35 is rolled out and the “Server-side pagination” feature has been included in this release. Please refer to the below code example and screenshot.


Code Snippet:

<PivotViewComponent

      // Customize page settings here.

       pageSettings={{

          rowPageSize: 10,

          columnPageSize: 5,

          currentColumnPage: 1,

          currentRowPage: 1

       }}

       // Customize pager settings here.

       pagerSettings={{

           position: 'Bottom',

           enableCompactView: false,

           showColumnPager: true,

           showRowPager: true

       }}

       // Enable Pager by enabling “enablePaging” option.

       enablePaging={true}>

    <Inject services={[Pager]} />

</PivotViewComponent>


Output screenshot:

Release notes: https://ej2.syncfusion.com/react/documentation/release-notes/21.1.35/?type=all#pivot-table


Kindly let us know if you have any concerns.


Regards,

Angelin Faith Sheeba


AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team March 24, 2023 04:54 PM UTC

Hi Oliveir,


Please find the sample here.


Regards,

Angelin Faith Sheeba.


Attachment: sample_c959c16f.zip

Loader.
Up arrow icon