AnsweredAssumed Answered

Allocations and ETCs Bulk Update

Question asked by nmanoha on Feb 6, 2014
Latest reply on Feb 6, 2014 by nmanoha

Hi Everyone,

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.)?

Thanks,

Pavithra.

Outcomes