Skip to Content (Press Enter)
UserImage.jpg
SSP
212Views
2Comments
Solved
Want to update records in bulk manner on third party database
Question
Reactive
External Database
OutSystems 11

Hi,


I want to update records in bulk manner on button click event. Some calculations will be done for each record based on some conditions and records will be updated in third party database. No API available here. 

I don't want to loop each record as for performance wise it's not good if size grow.

 I know various solutions for bulk insertion, including bulk insert forge component. But for bulk update I haven't found much documentation.

Let me know if anyone have suggestions!

Thanks in advance.


0
0
23 Jan 2023
Copy Link
2025-12-17 21-10-06
Shlok Agrawal
Solution

I have done with using the bulk insert forge component it didn't make the upload time faster comparatively. I suggest using for each loop with batch upload to avoid performance issues. Eg for 50000 records try construct a timer with 20 sec and only current 10000 records must be uploaded and reflected instantly now make a logic to upload next 10000 records and so on this is optimized without server being time out.

See solution in context
0
0
23 Jan 2023
Copy Link
2025-12-17 21-10-06
Shlok Agrawal
Solution

I have done with using the bulk insert forge component it didn't make the upload time faster comparatively. I suggest using for each loop with batch upload to avoid performance issues. Eg for 50000 records try construct a timer with 20 sec and only current 10000 records must be uploaded and reflected instantly now make a logic to upload next 10000 records and so on this is optimized without server being time out.

0
0
23 Jan 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.