I am migrating an app from Appmaker to Appsheet and found AppSheet to be debilitating slow. To test, I have Google Cloud SQL (MySQL) DB, 1 table, about 50K rows, no virtual columns, no relationships, no formulas, no DB functions, etc. It is taking about 15 seconds just for this. I wonder how has anyone built any serious business apps on this. Appmaker was so much faster - loads in a split second. It seems Appsheet is designed for small apps with 5K or less rows. We are only 20 employees and reaching 50K rows, how will any serious business use Appsheet when it is this much slow.
When I add more tables (8 tables, 50K rows in one table, 7K rows in 2nd and just a few dozens in other reference tables), it take 60+ seconds. At first, I thought this is due to Google Sheet. However after testing in Google Cloud SQL (in the US / Central region), performance barely improved. I have checked option to cache, delta sync, etc.
I have read performance tips mostly suggesting using security filter. In this case, a user should be able to reach/search/access any of the 50K records - so filter is probably not feasible.
Is there something I am missing?