Export excel with large dataset , Widget Lazy load

1. Currently, I developed a reactive web application and I need to export excel data (Large data like 100k record or more). Now, when User click export data it will sent .xlsx file via email (This action run asynchronous) , Is it Ok to get all data at once and send it, or I need to split it ?

2. Is reactive web app already provide a lazy-load on widget, and how it work?


Thank in advance.

Hi Kittisak

First use https://www.outsystems.com/forge/component-overview/355/advanced-excel to generate the excel it uses EPPlus library. 

And create a Timer to fetch the records and generate the excel and send mail. So that it runs in separate thread . For large dataset try to process the records in batches 

Trigger the timer from your reactive web app

Best Regards

Devendra


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.