Mehul Harry's DevExpress Blog

photo © 2008 Nathan | more info (via: Wylio)

Check out the speed improvements for exporting large amounts of data from DevExpress ASP.NET products.

Julian, our CTO, blogged about the improvements coming in our WinForms Grid exporting. And as Julian mentions in his post, the DevExpress engineers were challenged to improve the performance for exporting data. And they delivered!

Performance Increase In Numbers

Here's the actual breakdown:

What we used. The latest version of DXperience v2010.2 and a preview build for DXperience v2011.1.

What we timed/measured. We used 4 benchmarks:

1. ASPxGridView with 20,000 records and 5 columns. A quarter of a million cells.
2. ASPxGridView with 50,000 records and 5 columns. Half a million cells.
3. ASPxGridView with 100,000 records and 5 columns. A million cells.
4. ASPxGridView with 50,000 records and 10 columns. Half a million cells.

The results.

Take a look at these charts that show the big increase in performance:

Thanks Bryan, the DevExpress charting evangelist, for creating these slick charts using XtraCharts.

Faster Exports

The export performance is tremendous. For example, exporting a PDF with 100,000 rows is now 6 times faster. And exporting an XLS with 100,000 rows is 20 times faster!

You're end-users will feel the benefits immediately when you upgrade to DXperience v2011 volume 1. And you won't have to make any code changes to get the performance benefits!

Take a look at these charts to see the rate of change. As the number of rows is increased, the new exporting improvements only increase by small amounts:

Available now in v2011.1

What do you think of these new export performance improvements in DXperience v2011 volume 1 release?

Drop me a line below, thanks!