1. Home
  2. Forum
  3. ASP.NET Web Forms
  4. The PivotGrid control takes a lot of time to render a large amount of data.

The PivotGrid control takes a lot of time to render a large amount of data.

Hi

PivotGrid control no load.
I have an example that dynamically loads data from a query in SQL. Wheh the quantity exceeds 100000 records the control remains blank.

How can we improve performance?.


Regards

Olman Mora
DEINSA









3 Replies
MM Manikandan Murugesan Syncfusion Team December 11, 2017 11:17 AM UTC

Hi Olman, 
 
Thanks for contacting Syncfusion support. 
 
We recommending to using “Paging” option to overcome the performance problem for large data. Please refer below code snippet. 
Code Snippet: [aspx] 
<ej:PivotGrid ID="PivotGrid1" EnablePaging="true" runat="server" ClientIDMode="Static"> <DataSource> //... <PagerOptions CategoricalPageSize="5" SeriesPageSize="5" CategoricalCurrentPage="1" SeriesCurrentPage="1" /> </DataSource> </ej:PivotGrid> <ej:PivotPager ID="PivotPager1" runat="server" Mode="Both" TargetControlID="PivotGrid1"></ej:PivotPager>
 
Please refer the below documentation for more details about “Paging”. 
  
If still the problem exists, kindly send your dummy datasource to us with replicating the problem. It would be helpful for us to analyze the problem at our end. 

Thanks, 
Manikandan. 


OL Olman December 13, 2017 09:24 PM UTC

Hi Manikandan

Thanks for your response

I tried to use the paging but it does not work. The pivotgrid don't load.



MM Manikandan Murugesan Syncfusion Team December 14, 2017 04:55 PM UTC

Hi Olman, 

We are unable reproduce the reported problem at our end and prepared sample using Paging option. Please find the sample in below link. 

If still the problem exists, kindly send your sample that replicating the problem. This would be a very helpful for us to investigate the reported problem at our end and provide the solution at earliest. 
 
Thanks, 
Manikandan. 


Loader.
Up arrow icon