Hi,
We've had to update a property that is referenced on all our documents which means we will need to now update our documents and recalculate a new value(based on the changes to the updated property). We also have the requirement that we cannot update the last modified of the given documents as that will change the calculated value(retention period calculation).
We've created a SQL Update script that will update all the integer values directly to the db. we've run this on our dev vaults with no issue. Given that our production vault contains 500,000+ Documents/Objects can anyone suggest an alternative way of doing this or let me know of any alternative ways of efficiently updating objects at scale.
Also any risks we should be considering with process.
Any suggestions would be appreciated;
