XamPivotGrid is now fitted with rocket engines

Atanas Dyulgerov / Monday, October 24, 2011

The 2011.2 release has been a very busy one. Lots of new features and lots of improvements. The XamPivotGrid control got a lot of attention in the past few months and in addition to the new XamPivotDataSlicer control it also got a bunch of performance improvements. The results for our hard work are evident the moment you start your application with the control for the first time. Here are some figures:


11.1 RTM


Loading (100, 000 records)

2 s

0.5 s

Expanding (100, 000 records)

2 s

0,5 s

Dealing with 50, 000 members

50 s

2 s

Dealing with 3, 000, 000 records from SSAS

45 s

1.5 s

As you can see the startup time is reduced 4 times. The same speed improvement is present in the process of expanding hierarchies, which makes working with the pivot grid a pleasure. The real impressive numbers come when you're dealing with huge number of items. As you can see the new version of the control can deal with milions of data records 25-30 times faster than before.

The machine we've run the tests on is an Intel Core 2 Duo T9600 2.8GHz with 4GB RAM and Windows 7 64bit.

The speed improvements are no wonder as we have completely rewritten the way the MDX queries are constructed, we have optimized the algorithm for analysing the data and we've improved the way the result is built.

We hope you will enjoy our work!