Hello colleagues,
I work on an AppSheet database based app. It is that way for some legacy reason. It has substantial data and continuous use in production to easily attempt a migration to say Google sheets backend or RDBMS.
Anyway, the main query for this post is that the app requires daily deletes of old records that do not serve any business purpose. We do this through a scheduled bot with "For Each Row In Table" option and then having a suitable filter. The bot on an average is expected to delete anywhere between 500-1000 records per day from a table.
However either 1) using action in this scheduled bot or B) using Webhook with AppSheet API, or 3) using reference action to reference the rows to be deleted in an automation step, the number of rows deleted in any single bot run are in the vicinity of 200 max. This results in accumulation of undeleted rows and then a new issue of total bot failure due to the following reason of automation arises.
May I know if anyone of you also experience such an issue of late with AppSheet Database and any solutions, workaround you have implemented.
Around 3 months ago, this bot used to run on daily basis even though the number of records to be deleted daily were a bit lesser ( may be 20-30 % less) than the volume today.
However I would expect 500 -1000 records to be deleted at ease with at least Webhook API approach.
Update : As always it happens with this great community, if one searches enough, one is likely to get a great solution that has been already thought of. I will try to create another app with the concerned tables where deletes are required. This “only delete” app will not have any VCs and as such should run the bots much faster. Will try and report back.
Will also request any other thought, solution.