GetDataBuffer takes too much time to process
Dear Team,
I'm trying to understand what caused the low performance of my code. I see that it's because of many loops, but I'm wondering if there's any possible way to fix it:
Dim ResultDataB...
Forum Discussion
Hi, in addition to the above responses, I would also suggest to contemplate why there is data that needs to be set to NoData in the database in the first place. There may be good reasons for the need to do what you are trying to do here, but in most cases, this kind of data should e.g. be bypassed in the transformation rules, excluded from a copy routine (e.g. ACT to FC), or reclassified in order to provide a transparent and auditable data flow. Just deleting data may not always be in the best interest of the end user(s).
Also, as you know, calculated data data can be cleared with api.Data.ClearCalculatedData(), but here, O#Forms seems to be specified in order to remove data that has been manually entered (possibly?)? This may hint at changing other things such as adjusting the data access security so that users cannot enter data in unwanted combinations in the first place.
I am sure you have considered all of this already, so please also view this response in the light of the wider audience of this forum as I like to add words of caution for others reading this post to address their own solutions. 🙂