We've built a process which will update the Allocations and ETCs of all inactive Projects to 0.
There are over a 104,000 rows for which the update will happen, through XOG.
We are planning to create 2 One-Time Processes - one will update ALL Allocations and the other, ALL ETCs.
After this activity is done, after all is zero-ed out, we are scheduling these two jobs to run weekly (since the records to be updated will be less)
My question: What would be the impact of running a bulk update process as mentioned above? Should I consider a better practice (ex: Running these processes in batches of 100 Projects at once etc.)?