Mike Allen
Mega Sage

You could use setLimit to break it up, if you want.   You could put it in a scheduled job to run every night for a certain number of nights to reduce load on the system.   You could add specific conditions to try to get your set down to something smaller.   You could engage HI support to see if they are willing to run this on the database level, which would make it much quicker.   There are options, just depends on how long you want to wait.


View solution in original post