Hello all,
We are working on purging records and are finding that each record takes quite a long time to purge. This makes us hesitant to run the report with all the records since it takes a long time.
We are considering breaking it out and running portions of the file overnight for a few nights. Has anyone encountered this, and what did you do to remedy it?
Thanks,
Susan
Hi Susan thanks for posting! It might be an idea to cross-post to the Database Managers Community group? Hopefully you might get an answer over there. - Gill, Community Manager
Hi Susan - we're undertaking this very project currently. We are self-hosted and are testing the purge utility. So far, 10 records took 7 minutes yesterday, but 20 records took only 6 minutes today. It's very difficult to anticipate how long this will take when any given day, your results will vary. I think for us, managing it in very small chunks, over a period of time is the way to go Jen Skelly