My process runs super slow. Initially it used to finish in around 5 mins but lately it takes around 14 mins on an average to complete one transaction sometimes even more. I debugged and found issue in my write cell activities which I use to update my status file at various stages of my process. Write range will not serve my purpose. Anyway to deal with the issue?. Thought of creating a datatable and updating it at various stages but gonna be a huge change.
Pls advise some way to address the issue.