In my last blog, I mentioned that we'll explore the possibilities with Google App Script (GAS) to create a spreadsheet. In this post, I'll show my thoughts on how to create Spreadsheet with the help of JSON file.
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. On database side, we were already using paginated query and the query was fine tuned with database indexing. Our report runs that query and collect all data to be exported in excel file. We are using ColdFusion POI utility to create an excel file. POI provides numbers of features for formatting with custom tag approach.