Hi everyone. I'm using Google Sheets for my database and it has 32 tables, of which the largest 2 tables have 18,000 and 4,000 rows respectively. The remaining 30 tables range from 1,000 rows or so down to only 20 rows.
Appsheet is REALLY slowing down and my team members are chewing me up everyday because sync times are taking so long. FYI I have already removed all expensive virtual columns calculations.
I have been wondering whether AppSheet slows down because it processes the entire Google Spreadsheet (all 32 tables)? If I extract my table containing 18,000 rows into its own Spreadsheet file, would that speed things up (isolated files are each lighter), or will it slow things down more (more back and forth between two isolated files)? Apologies that I am not more articulate with the correct vocabulary. I'm not IT-trained, just doing what I can for the company. Thank you for your inputs!
LinkedIn
Twitter
