Hi community,
I’m looking for some advice and experiences from anyone who has faced a similar situation:
I currently have an AppSheet app that started with a small number of records using Google Sheets as the data source. From the beginning, I implemented partitions to maintain performance — initially every 6 months, then every 3 months, and now I’m having to partition monthly as I’m exceeding 60,000 records per month. I’m concerned that as the data continues to grow, the frequency of partitioning will become unsustainable.
Because of this, I’m considering migrating to an SQL database. However, I have several questions and would really appreciate your insights:
- Do SQL databases have record limits that affect performance, like Google Sheets does?
- If, for example, I reach over 2 million records in a couple of years, would I still need to create partitions? Would the app performance remain stable?
- How can I manage image storage so that user-uploaded images are saved in a Google Drive account different from the app creator's Drive?
- Which Cloud SQL service would you recommend to start with for this migration and testing? I'm looking for something accessible but stable enough to handle this data volume.
Any recommendations or shared experiences would be greatly appreciated.
Thank you all in advance for your time and support!
LinkedIn
Twitter
