I have a database that has around 200k rows.
I have been using Appsheet API to try and delete the records for about 70% of the database, but it seems so slow (even though I created a new app just to tackle this problem).
What am I doing wrong, and what should I have been doing instead?
Use an SQL database as your data source.
I see, so there’s no better way. Good thing we’re in the process of transitioning from Appsheet DB to Postgres. Anyways, thanks !!
Hey,
Hope you’re keeping well.
Deleting large volumes of rows via the AppSheet API can be slow because each API call processes row changes individually. For bulk deletions at this scale, it’s more efficient to perform the operation directly at the data source level (e.g., using SQL DELETE in your database or bulk operations in Google Sheets/BigQuery) rather than through AppSheet’s sync layer. Once the deletion is done at the source, trigger an AppSheet app sync to refresh the dataset. If you must use the API, consider batching requests into larger payloads and disabling unnecessary automation while the bulk job runs to reduce overhead.
Thanks and regards,
Taz