# Deleting a whitelist entry, using web interface

**URL:** <https://discourse.pi-hole.net/t/deleting-a-whitelist-entry-using-web-interface/27151>\
**Category:** Beta 5.0\
**Created:** [January 20, 2020, 10:53am UTC](https://discourse.pi-hole.net/t/deleting-a-whitelist-entry-using-web-interface/27151 "2020-01-20T10:53:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jpgpi250](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/jpgpi250/32/286_2.png) [@jpgpi250](https://discourse.pi-hole.net/u/jpgpi250)\
**Post date:** [January 20, 2020, 10:53am UTC](https://discourse.pi-hole.net/t/deleting-a-whitelist-entry-using-web-interface/27151/1 "2020-01-20T10:53:10Z")

</div>

When I delete an entry from the `whitelist`, using the web interface, the entry is removed from the table `domainlist`, however the corresponding entry in the table `domainlist_by_group` is NOT deleted. Doesn't that entry need to be removed. This may impact long term database performance and size, I think …

Thanks for your time and effort

---

<div class="post-metadata">

**Author:** ![jpgpi250](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/jpgpi250/32/286_2.png) [@jpgpi250](https://discourse.pi-hole.net/u/jpgpi250)\
**Post date:** [January 20, 2020, 11:43am UTC](https://discourse.pi-hole.net/t/deleting-a-whitelist-entry-using-web-interface/27151/3 "2020-01-20T11:43:21Z")

</div>

Automatically regenerated by pihole?

I ran `pihole -g`, the obsolete entries remain in the database

---

<div class="post-metadata">

**Author:** ![DL6ER](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/dl6er/32/281_2.png) [@DL6ER](https://discourse.pi-hole.net/u/DL6ER)\
**Post date:** [January 20, 2020, 4:23pm UTC](https://discourse.pi-hole.net/t/deleting-a-whitelist-entry-using-web-interface/27151/4 "2020-01-20T16:23:48Z")

</div>

> [@jpgpi250](#):
>
> the corresponding entry in the table `domainlist_by_group` is NOT deleted.

Thanks for pointing this out, I will add a database trigger for this job (together with my change for your other question).

> [@jpgpi250](#):
>
> This may impact long term database performance and size, I think …

The gravity database is separate from the long term database, but yeah, sure.

---

<div class="post-metadata">

**Author:** ![DL6ER](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/dl6er/32/281_2.png) [@DL6ER](https://discourse.pi-hole.net/u/DL6ER)\
**Post date:** [January 20, 2020, 5:04pm UTC](https://discourse.pi-hole.net/t/deleting-a-whitelist-entry-using-web-interface/27151/5 "2020-01-20T17:04:36Z")

</div>

[https://github.com/pi-hole/pi-hole/pull/3089](https://github.com/pi-hole/pi-hole/pull/3089)