# Slow Database Partial Fix

**URL:** <https://forum.bubble.io/t/slow-database-partial-fix/375254>\
**Category:** Tips\
**Created:** [July 8, 2025, 1:57pm UTC](https://forum.bubble.io/t/slow-database-partial-fix/375254 "2025-07-08T13:57:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ed19](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ed19/32/193092_2.png) [@ed19](https://forum.bubble.io/u/ed19)\
**Post date:** [July 8, 2025, 1:57pm UTC](https://forum.bubble.io/t/slow-database-partial-fix/375254/1 "2025-07-08T13:57:52Z")

</div>

Hi all,

Just a quick tip for something I’ve only just noticed, which is that the bubble db UI is fully loading every single entry for every single deleted field on any datatype you are viewing. Only just thought to inspect it for the first time in 3+ years, and immediately saw that one of my datatypes was loading multiple megabytes of data from a dead field.

Quickest way to resolve this was to use the app optimisation tool, unselect all (for safety and speed!), then search for the field in question, running the optimiser on that field only. Was an instant fix in my case, for errors I created before I knew how to use the platform properly.

Thought I’d share since it’s saved me a lot of headache, hope it’s helpful.

---

<div class="post-metadata">

**Author:** ![sudsy](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/sudsy/32/114637_2.png) [@sudsy](https://forum.bubble.io/u/sudsy)\
**Post date:** [July 8, 2025, 4:17pm UTC](https://forum.bubble.io/t/slow-database-partial-fix/375254/2 "2025-07-08T16:17:50Z")

</div>

I would actually add a couple steps. Below is the procedure I follow to remove a no-longer-needed field from the DB:

1. Remove all **references** to the field (use the editor search tool).
2. Delete the field **data**.
3. Delete the **field** itself.
4. Optimize the app to **purge** the deleted field from the app.

That’s the way I’ve always done it because it “made sense”, but you can check [this recent thread](https://forum.bubble.io/t/data-deleted-or-not-security-concern/342232) for some insights and rationale.

-Steve

---

<div class="post-metadata">

**Author:** ![randomanon](https://avatars.discourse-cdn.com/v4/letter/r/8491ac/32.png) [@randomanon](https://forum.bubble.io/u/randomanon)\
**Post date:** [July 9, 2025, 2:44am UTC](https://forum.bubble.io/t/slow-database-partial-fix/375254/3 "2025-07-09T02:44:26Z")

</div>

Yeah, I would add one more step just to be safe. Between steps 1 and 2, go into your privacy rules and make sure there’s only a single rule with everything unchecked.
