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

Free DevExpress Products - Get Your Copy Today

The following free DevExpress product offers remain available. Should you have any questions about the free offers below, please submit a ticket via the DevExpress Support Center at your convenience. We'll be happy to follow-up.
No Comments

Please login or register to post comments.