It really depends how many items you will have in your database. I normally just “archive” things because it is instant for the user and makes for a better UX.
You can set up a backend workflow that deletes that item after a certain amount of time only if the item is still archived. Check out Schedule API Workflows. https://bubble.io/reference#Actions.ScheduleAPIEvent