# Data Pruning Question

**URL:** <https://forum.inductiveautomation.com/t/data-pruning-question/89837>\
**Category:** Ignition\
**Created:** [May 2, 2024, 4:24pm UTC](https://forum.inductiveautomation.com/t/data-pruning-question/89837 "2024-05-02T16:24:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pico\_Sankari](https://avatars.discourse-cdn.com/v4/letter/p/aeb1de/32.png) [@Pico\_Sankari](https://forum.inductiveautomation.com/u/Pico_Sankari)\
**Post date:** [May 2, 2024, 4:24pm UTC](https://forum.inductiveautomation.com/t/data-pruning-question/89837/1 "2024-05-02T16:24:11Z")

</div>

Does having data pruning enabled effect data on a database that is not from historized tags? This would be tables coming from transaction groups and SQL queries.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 2, 2024, 4:35pm UTC](https://forum.inductiveautomation.com/t/data-pruning-question/89837/2 "2024-05-02T16:35:06Z")

</div>

No. You could just run a scheduled task on those to delete records older than a set number of days. If you check your database you'll find that there is only one table for the transaction group and no partitioning - unless you've done something complicated!

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [May 2, 2024, 4:52pm UTC](https://forum.inductiveautomation.com/t/data-pruning-question/89837/3 "2024-05-02T16:52:33Z")

</div>

Transaction groups have a "pruning option" built-in.

---

<div class="post-metadata">

**Author:** ![Anantharaman\_Nagaraj](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Anantharaman\_Nagaraj](https://forum.inductiveautomation.com/u/Anantharaman_Nagaraj)\
**Post date:** [August 18, 2025, 8:36am UTC](https://forum.inductiveautomation.com/t/data-pruning-question/89837/4 "2025-08-18T08:36:15Z")

</div>

is that so? have you tried

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [August 18, 2025, 8:56am UTC](https://forum.inductiveautomation.com/t/data-pruning-question/89837/5 "2025-08-18T08:56:18Z")

</div>

Yes, they have…

 ![Screenshot_190](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/7/072728ca54684bbe428bceba3777794113c437e8.png)

---

<div class="post-metadata">

**Author:** ![Anantharaman\_Nagaraj](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Anantharaman\_Nagaraj](https://forum.inductiveautomation.com/u/Anantharaman_Nagaraj)\
**Post date:** [August 18, 2025, 9:30am UTC](https://forum.inductiveautomation.com/t/data-pruning-question/89837/6 "2025-08-18T09:30:48Z")

</div>

Thanks