Delete a long list of things from logs database

michal.friedrich · 2024-12-31T12:48:50.062Z

I have a database of logs which I use to track events in my app.
I have a very long list of them ~400 000 elements.
I want to create a workflow / datatrigger that will delete all records older than 1 month. (delete a list where elements created date is older than current date minus 1 month)

What will be the price if I want to delete so many items? Will I be charged for every single thing I delete if it will be a delete a list workflow?

What if I delete them from editor panel - will there be a price for that as well? As I may also resolve to this solution as I create way less records now.

What is the best approach costwise / performance wise?

georgecollier · 2025-01-01T11:53:22.663Z

You’ll be charged 0.5 WU per Thing deleted.

Delete a list of Things WU cost =

0.5 WU per thing in the list (deletion)
0.3 WU for search to find the things to delete
0.015 WU per thing in the list (search results returned)
0.6 WU for server-side workflow action

boston85719 · 2025-01-01T12:22:00.371Z

michal.friedrich:

What if I delete them from editor panel - will there be a price for that as well?

Yes, cost to delete each item, but I don’t there is any other costs

michal.friedrich · 2025-01-02T07:44:02.547Z

Thanks for those amazing responses! bubble community is amazing!