Results 1 to 2 of 2

Thread: CF9 - Creating spreadsheets with cfspreadsheet using spreadsheetAddRows() is slow

  1. #1

    Default CF9 - Creating spreadsheets with cfspreadsheet using spreadsheetAddRows() is slow

    There is slowness when creating spreadsheets with <cfspreadsheet> while using the function spreadsheetAddRows(). According to reports for 100 rows approximate time is 1 second or more, 250 rows 20+ seconds. This is a known bug in ColdFusion 9, and there is currently no fix provided by Adobe for this problem. The known work around for this issue is to use Ben Nadel's POI Utility. Using the POI Utility the same 250 rows created takes less than one second.

    See Adobe Bug Report for slowness using spreadsheetAddRows().
    Jon Cavanaugh
    ColdFusion Systems Analysts
    Director of Business Development
    Linux Hosting | Christian Hosting | Railo Hosting

  2. #2

    Default UPDATE - ColdFusion 9.0.1 Patch fixes issue in 9.0.0

    Adobe fixed this function in the 9.0.1 update, to fix they suggested testing the code on a 9.0.1 server before hand.

    Secondly, instead of using the POI utility which is not designed for speed but overall flexibility, the tag <cfspreadsheet> can be used in replacement of the spreadsheetAddRows() function, customers reporting 1000% increase in speed using the tag vs the function.
    Jon Cavanaugh
    ColdFusion Systems Analysts
    Director of Business Development
    Linux Hosting | Christian Hosting | Railo Hosting

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •