Forum Academy Marketplace Showcase Pricing Features

Deleting Thousands of Records in Bulk

Hi All,

I have read the forums over the last few days regarding this topic and can’t seem to find a definitive answer.

Basically, I have a list of things called “Interval_reports” I am pulling data from GPS tracking units using an API and storing it in the Bubble database. there is no media only 4 text/number fields. The problem is that I am now sitting with over 250k entries and no matter what I do I cannot seem to bulk wipe/delete (paid plan)

I have tried using a workflow (Delete a list of things on button click) this just eventually times out the app and doesn’t delete a single record. I am not sure how to configure a backend workflow to achieve this or if that will eleven work. Besides this my database is tiny.

I have enjoyed Bubble for many years and this truly has been the only major frustration I have had. I don’t understand why it is so difficult to delete thousands of entries using a simple function. Am I missing something or does anyone have a solution around this? I’m sure I am not the only user who deals with huge amounts of entries that require deletion (especially when testing)

Thanks Appreciate any assistance.

Try to delete the list of things by few chunks and check for the old records and do the same for deletion with list of chunks.

But when deleting lot records in a single workflow will won’t work. Spitting into chunk of process can surely works, I’m using this procedure for removing large number of records.

Place a button and call schedule an API workflow on click. In API endpoint add an action delete a list of thing and provide the desired data source. Than just click that button once from frontend, it will delete all the record in backend and also you don’t need to stay on page to wait for workflow completion.

How would I go about doing this? I have placed a button, the schedule an API workflow however there are no workflows listed. This is the backend workflow I would like triggered on button click. I’ve probably not done this correctly. I don’t use backend workflows in bubble often.