Hello Experts,
I have an AppSheet leveraging an AppSheet Database. I have found that when using AppSheet Database compared to using Google Sheets the delete row performance is extremely different. The AppSheet DB is exponentially slower, and it seems to perform deletes operations sequentially a row at a time. I have reviewed the Performance Monitor and I can see it takes just under a second to successfully delete a row. The table is a child to a customer table. It does have 2 virtual columns that have cross table references. But, I would have thought on a delete operation the virtual column computation would not be involved. And I cannot see any reference to that in the Performance Monitor view. In the action I have that does all the clean-ups there is a number of sub actions. The three sub actions that delete records from child tables of customers; all use a Filter to select the rows; and the Delete operation. Could the issue be the Filter as the means to select the rows? I had assumed it would only perform the Filter once, get the row references and then delete all the rows as a single step.
Any advice would be hugely appreciated.
LinkedIn
Twitter
