0 Replies Latest reply on Aug 17, 2011 1:06 PM by bvenrockford

    cfspreadsheet timing out

    bvenrockford
      • ColdFusion version:9.0.1 standard
      • server OS: Windows 2008 R2
      • webserver: Apache 2.2.19

       

      I've been having great luck with the new spreadsheet tool.  I have a report that works correctly with anything less than 1000 rows or so.  I am not sure if it is my code that is causing the issue, or if it is related to another post (http://forums.adobe.com/message/3318663#3318663).

       

      Basically I am getting a list of accounts and then looping through those accounts, adding a monthly total, and then adding grand total for each account.  If the account (or multiple accounts) has less than 1000 rows, it takes all of 1 second for it to spit out my report.  If the account query has more than 2000 rows though, even with setting my timeout to 5 minutes, I will get nothing.  I am using .xlsx format because the final report with have around 200k rows.

       

      My code is here:  http://pastebin.com/7T2rhW80

       

      If it would be helpful to copy it to this site, please let me know.

       

      As before, any help would be appreciated.