# Best Logic Approach for Mass Deletes

**URL:** <https://community.nextw.com/t/best-logic-approach-for-mass-deletes/1158>\
**Category:** Nextworld Platform\
**Tags:** logic-blocks\
**Created:** [September 11, 2025, 3:34pm UTC](https://community.nextw.com/t/best-logic-approach-for-mass-deletes/1158 "2025-09-11T15:34:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![claire.minnaar](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/claire.minnaar/32/199_2.png) [@claire.minnaar](https://community.nextw.com/u/claire.minnaar)\
**Post date:** [September 11, 2025, 3:34pm UTC](https://community.nextw.com/t/best-logic-approach-for-mass-deletes/1158/1 "2025-09-11T15:34:47Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![ian.p](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/ian.p/32/427_2.png) [@ian.p](https://community.nextw.com/u/ian.p)\
**Post date:** [September 11, 2025, 3:40pm UTC](https://community.nextw.com/t/best-logic-approach-for-mass-deletes/1158/2 "2025-09-11T15:40:31Z")

</div>

I would recommend configuring a `Data Purge Definition` for this purpose. Are you invoking this manually or is it happening via logic?

---

<div class="post-metadata">

**Author:** ![claire.minnaar](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/claire.minnaar/32/199_2.png) [@claire.minnaar](https://community.nextw.com/u/claire.minnaar)\
**Post date:** [September 11, 2025, 3:43pm UTC](https://community.nextw.com/t/best-logic-approach-for-mass-deletes/1158/3 "2025-09-11T15:43:15Z")

</div>

> [@ian.p](#):
>
> Are you able to invoke 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.

---

<div class="post-metadata">

**Author:** ![ian.p](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/ian.p/32/427_2.png) [@ian.p](https://community.nextw.com/u/ian.p)\
**Post date:** [September 11, 2025, 6:20pm UTC](https://community.nextw.com/t/best-logic-approach-for-mass-deletes/1158/4 "2025-09-11T18:20:07Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![claire.minnaar](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/claire.minnaar/32/199_2.png) [@claire.minnaar](https://community.nextw.com/u/claire.minnaar)\
**Post date:** [September 11, 2025, 6:35pm UTC](https://community.nextw.com/t/best-logic-approach-for-mass-deletes/1158/5 "2025-09-11T18:35:41Z")

</div>

It would be dynamic, @ian.p and not something we can standardise/define once off.

---

<div class="post-metadata">

**Author:** ![brendan.b](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/brendan.b/32/269_2.png) [@brendan.b](https://community.nextw.com/u/brendan.b)\
**Post date:** [September 26, 2025, 2:10pm UTC](https://community.nextw.com/t/best-logic-approach-for-mass-deletes/1158/6 "2025-09-26T14:10:31Z")

</div>

See guidance posted [here](https://community.nextw.com/t/handling-large-scale-deletions/1248).