Hi,
Could you give me a practical example about this best practice? It's not clear to me what "manipulate with excel" means. Maybe this is when we will initialize an Excel? Or will it be when we convert a record list to Excel? or something different? And if possible, could you show a small example of this timer?
https://success.outsystems.com/documentation/best_practices/performance_and_monitoring/performance_best_practices_data_model/
Best Regards,
Jessica Marques.
Hello,
What this basically means is that, if you need to upload and process large Excel files using the "Excel to Record List" tool, you shouldn't do that in a synchronous way. That is, the user shouldn't upload a file, click a button and then wait until the Excel file is processed.
What you should do instead is save the uploaded file as binary to the database and trigger a timer that will read that database entity and process the data in the background.
Hi @Aurelio Junior
Thank you very much for your explanation, it was exactly what I needed to understand this point.
Regards,
Hi @Jessica Marques ,
Have you checked the below course:
https://learn.outsystems.com/training/journeys/async-processing-timers-586
forge link:
https://www.outsystems.com/forge/component-overview/6111/large-file-data-import-sample
In the end, it's all depend upon the use case. There is no one solution fit to all. It all depends upon your logic and requirement but I hope you get some idea from above examples.
Hope it helps.
Manish Jawla
Hi @Manish Jawla
Thanks for the shared links. It will certainly help in understanding the model for the timer, in this case of large data