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
The immediate suggestion would be to use FilterMembers instead of looping through accounts and ICs:
Dim sourceBuffer as DataBuffer = api.Data.GetDataBufferUsingFormula( _
"FilterMembers(RemoveZero(A#All:O#Forms:U1#Whatever:etcetc), A#account1, A#account2, I#ic1, I#ic2, [etc etc]")If you really want, you can then loop through the records in that buffer to set all cells to zero.