Tackling Timeout Issue with Creating Spreadsheet Using ColdFusion POI Utility
Timeout is a well know issue not only with POI spreadsheet, but it applies to process which consumes resources. As the data grows, you'll need more CPU power and more memory. If you are using MS SQL or MY SQL, then you must have created a query with paging concept. Limiting number of records per request will help you to get rid of the timeout issues.
Our client runs a daily report for their business. As their business grow, report data also grows and this leads a timeout issue. ORead More