I am currently evaulating XamPivotGrid using FlatDataSource. I just started testing the performance of the grid by binding the flatdatasource to a List containing about 1 million items. My source object class contains about 6 members out of which two are measures while rest are dimensions. The 1 million items span across 50,000 unique dimensions. Initially when I load the grid, there is only one dimension in the "Rows Fields" section and the two Measures in the "Data Items' section. So when I first load the grid it takes a while but eventually it does load up. However the real performance bottleneck occurs when I start adding more dimensions in the "Row Fields" section. It gets very slow and even causes Internet explorer to crash.
Is there a way to speed up the performance of the XamPivotGrid? Is pagination available for XamPivotGrid?
Hi,
Developers have reviewed the sample that was provided and determined that it was not a development issue.
I am having a similar issue.
Todor has asked that I log a development issue for this behavior; performance issue when binding to large data source and adding multiple row dimensions.
I’m in the process of doing that and I will contact you shortly thru a case I have created in order for you to track the development issue’s status.
Hi
I am going to invetsigate your scenario and will keep you in touch for posible solution
RegardsTodor