Hi,
I am working on uploading data using the CSV file. The CSV file contains lots of records. Before uploading these records to the database, I have to do some checking against the different databases using SQL. Due to this, it takes lots of processing time. Can you please suggest a different approach for handling the bulk uploads? I don't use modules from Forge.
Thank you so much in advance.
One solution you can use is to disconnect the upload process from the processing of the records themselves. Put simply, store your CSV records in a staging entity and then wake a timer to process the records.
This article might assist: https://medium.com/@insideoutsystems/disconnect-data-processing-in-outsystems-6c06cb9e6a06