I have an activity which updates records in the database. The no. of records processed in one run is generally more(>1000). So, I am curious to know which method of saving data is better in terms of performance ?Which is faster?
Obj-Open & Obj-Save on a temporary clipboard page.
Using a savable data page to update the record
***Edited by Moderator Marissa to update Platform Capability tags****
@pavan3753 I can loop through the list of records and map each record to a page type savable data page then use Save-DataPage method inside the loop to save each record one by one without using Obj-Save.
@VittalSai Can we implement any exception handling with DataSet-Execute method ? As I see data set processes a collection of records at one go it is difficult to implement error handling for each record like we do in Obj-Save.