If we have a process which needs to delete a large number of records, what is the best approach to follow (performance wise) e.g. Chunk Fetch and delete in a new transaction, do it in batches in new transactions, fetch and delete, background task, etc?
I would recommend configuring a Data Purge Definition for this purpose. Are you invoking this manually or is it happening via logic?
@ian.p At the moment, it would be kicked off in some cases with a row action/form action or via a logic block when certain conditions are met.
It’s fine to execute a Data Purge by calling the same logic block that is available on the Data Purge Definition app as a row action or from a logic block directly from elsewhere. However, do the purge criteria change dynamically or can a static purge definition be set up once and then repeatedly invoked?
It would be dynamic, @ian.p and not something we can standardise/define once off.
See guidance posted here.
2 Likes