Is there a way to validate data on Update_Recordset even if we skip table data methods?

(1) Share

Report

Posted on by JohnBright

115

Hi experts,

I am updating a table through update_recordset. This table has mass data. To optimize the performance of updation, I have skipped the data methods through skipdataMethods option. But now, the client needs to validate records on updating. I am exploring is there any way that we could still validate the records on updating through update_Recordset even after skipping the methods? This question might be senseless. I understand validating by not skipping the data methods is the best practice. But just exploring is there any other way that we could validate without sacrificing the performance?

Thanks in advacne,

John

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi John,

I don't think it's possible. Update_recordset will fall back to record-by-record operation once you remove the skipdataMethod(true) and that's because the update method of the table will have some logic.

So if you want to validate each record you want to update, I don't think it makes sense for update_recordset to work without sacrificing performance.

Thanks,

Layan Jweihan

Was this reply helpful? Yes No
André Arnaud de Cal... 305,398 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi John,

Like Layan mentioned, you would lose performance when validating the records. You can also consider running another batch job for validating the records afterwards, but that depends on the severity of the validation.

Was this reply helpful? Yes No
Verified answer

Kevin Xia Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi,

As Andre said, instead of processing all the data at once using update_recordset, you can split the data into smaller batches. After processing each batch, you can apply data methods for validation. This way, you can ensure that data is validated periodically without sacrificing too much performance.

Best regards,

Kevin

Was this reply helpful? Yes No