I'm getting this error when a complex query is run. It has multiple inner joins and is returning potentially thousands of records with about 60 columns each.
------- The request has exceeded the allowable time limit Tag: cfoutput The error occurred on line 111. ------- Is it timing out when retrieving the data? Or is it when trying to output the data? We're using CFMX 6.1 with mySQL 4.0.17. It's a legacy application that hasn't been touched in several years. But lately the client says she has been getting these errors. The problem is that the app wasn't really written to scale well. We're looking at setting up a paging system for her instead of trying to display all of the info at once. Anyone have any wisdom on this though? <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243463 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
