I have an Excel app that I am attempting to convert to a web app using igPivotGrid. There are 700,000 rows in the database table. It seems that I need to send all the rows to the igPivotGrid and not just some subset based on the filtering that the user sets. Is this true or am I missing something? None of the examples that I found filter on the datasource.
The igPivotGrid has two options to connect to data:
Given the volume of data that you have the only option I can suggest is that you move your data to a Microsoft® SQL Server Analysis Services cube and request it from there.
Best regards, Martin Pavlov Infragistics, Inc.
Thank you. I have moved to SSAS (a learning curve for me) and am getting good performance.