ASP.NET PDF/XLS Export Speed Increased! (available now in v2011.1)

ASP.NET Team Blog
10 May 2011

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:

Exporting 50 Rows with 10 Columns 

Export PDF with 5 Columns 

Export XLSX with 5 Columns

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:

XLSX export: Rate of change PDF export: Rate of change

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!

Save time and money...

Save time and money with high quality pre-built components for ASP.NET, Windows Forms, WPF, Silverlight and VCL as well as IDE Productivity Tools and Business Application Frameworks, all backed by world-class service and support. Our technologies help you build your best, see complex software with greater clarity, increase your productivity and create stunning applications for Windows and Web in the shortest possible time.

Try a fully-functional version of DXperience for free now: http://www.devexpress.com/Downloads/NET/

Follow MehulHarry on Twitter

9 comment(s)
Christopher Todd
Christopher Todd

WOW!! Impressive!

10 May, 2011
James Zhong
James Zhong

Very good improvement on Excel/PDF exporting speed! The 2010.1 and 2010.2 are too slow to export huge data.

10 May, 2011
Mark Williams
Mark Williams

Great!  It's a little worrisome that such a huge performance improvement went unnoticed/not fixed for so long.  I look forward to hearing more about v2011!

11 May, 2011
EricH
EricH

Very, very excited for this improvement, Mehul! Is June or July still time frame for deployment of 11.1?

11 May, 2011
Mehul Harry (DevExpress)
Mehul Harry (DevExpress)

Thanks everyone!

Eric, Yes, the 2011.1 release should probably be around the June 2011 timeframe.

11 May, 2011
Fırat Esmer
Fırat Esmer

Yay!

11 May, 2011
James Birnie
James Birnie

Great work team!

17 May, 2011
Robert Miclescu
Robert Miclescu

Hello,

I have a question regarding the time that is necessary to export excel files using your 4 benchmarks. How much time elapsed since you started the export, until the excel file was ready?

In your article, you just showed that there are improvements, but you did not say anything about how long should an export take :)

Thank You

22 July, 2011
Mehul Harry (DevExpress)
Mehul Harry (DevExpress)

Robert,

Please take a look at the charts again as 'Elapsed Time' is displayed.

Hope that helps, thanks.

-Mehul

22 July, 2011

Please login or register to post comments.