Blogs

News

Email Subscriptions

Mehul Harry's DevExpress Blog

WPF Pivot Grid Speed Improvements

     

Check out these performance improvements for the DevExpress WPF Pivot Grid, DXPivotGrid:

  • Field values now expand and collapse twice as fast.
  • Improved scrolling speed in the Summary Type Display mode. The scrolling using the left/right arrow keys is now much faster.

How fast?

Here’s a project that uses our WPF Pivot Grid in a data intensive scenario:

DevExpress WPF Pivot Grid

To measure the difference, we took a couple of traces of the operations. For the trace, I've collapsed and expanded the first row area group in the WPF Pivot Grid project (screenshot above).

Here’s the results: 17,711 ms before and 7,106 ms after - expanding is two times faster!

Trace - Before Trace - After

Coming Soon

Unfortunately, these improvements are not in the latest release of DXperience v2010.1.5 yet. They will be in a future release so stay tuned.

Drop me a line below with your thoughts.

I'm on twitter

Published Jul 14 2010, 08:35 AM by Mehul Harry (DevExpress)
Filed under: , , ,
Technorati tags: WPF, Features, Pivot, Performance
Bookmark and Share

Comments

 

James Foye said:

Cool.

I noticed the Excel export is missing in WPF, that would be kind of nice to have again.

July 14, 2010 3:43 PM
 

Mehul Harry (DevExpress) said:

@James,

Thanks. The regular DXGrid can print/export just fine. The DXPivotGrid will get this feature in the future. Track this suggestion to get updates on it's progress:

www.devexpress.com/issue=Q243812

July 14, 2010 3:50 PM
 

James Foye said:

Yeah, sorry, I just meant the pivot grid. I have started tracking that suggestion.

July 14, 2010 4:15 PM
 

Linton said:

How many records are in your test data set?

July 16, 2010 12:06 PM
 

Ivan N (DevExpress R&D) said:

@Linton,

Not so big. Our main problem on WPF-platform is drawing performance. This is the case we were able to overcome WPF limitations. To demonstrate an issue better, we have configured the PivotGrid to show many small cells.

July 17, 2010 7:28 AM

About Mehul Harry (DevExpress)

Mehul Harry is an ASP.NET technical evangelist at Developer Express. You can reach him directly at mharry@DevExpress.com. You can also follow him on Twitter: http://twitter.com/mehulharry
More from DevExpress
Live Chat
Have a pre-sales question?
Need assistance with your evaluation?
We are here to help.
Chat is one of the many ways you can contact members of the DevExpress Team. We are available Monday-Friday between 8:30am and 5:00pm Pacific Time.
If you need additional product information, require pre-sales assistance, or want help with your order, write to us at info@devexpress.com or call us at
+1 (818) 844-3383.