Hey there,
I have a table with millions of records in it. I have been exporting this to an external database so I no longer will be needing it in Bubble. Anyone who has tried to delete data manually from the Bubble backend will know that it is simply not viable to delete such a large amount of data without slowing your app to a crawl and taking probably months (no exxagerations).
I notice that you can simply delete the table with a single click but then it can be restored so is this a fake delete with the records still kept on my resources?
Any ideas on the best way to cleanse this without taking up a ton of resources and time. I’d prefer if the data was fully deleted rather than hidden.
I’m not sure why data management is so difficult on Bubble but hey ho, I can leave my tales of migrating out millions of records to another post.
Just thought I’d bump this as there are many eyes on the forum right now and it would be great if anyone has some experience 
Delete a list of things works well, just do it in batches of 10,000ish.
I look forward to Adam’s reply on this 
1 Like
If you delete the table and then optimize the app from Settings tab, that will be hard delete. You will not be able to restore the fields after that.
From what I have noticed, the data is also no longer accessible after optimize. However, it would be good to know if they delete it or not.
1 Like
interesting, I have never used that optimize before! Would also be curious to know if that is a hard delete if anyone from Bubble could find out / ask @fede.bubble .
I just don’t want to get to a point down the road where this millions of records becomes a hindrance with the new pricing plans coming in and if I am forced to do something with them later that costs me a ton of WUs then that would leave a bit of a sour taste in my mouth.
I know… Bubble is crazy slow and expensive for this type of thing, so using delete a list of things, and running it however many hundreds/thousand times you need to cover all your millions or records is the only way to do this.
You can indeed use the ‘Optimise app’ feature to permanently delete datatypes/fields that have previously been deleted.
However, I’m not convinced that actually delates any data - or even stops it being accessible.
(I always understood this was the case, but in some recent tests, even after deleting fields, and then ‘permanently removing’ them with the Optimise app feature, the data from those ‘deleted’ fields was still being loaded to the page anytime the Datatype in question was used.
But that was deleting a field - in your case you’re deleting the entire table, so it should;dn’t be an issue).
2 Likes
