I have a massive (2M+ records) database I’ve built and been maintaining for close to 20 years for a popular website similar to imdb. I’m thinking of moving that to a glideapp. Here are the questions before I embark on this.
I see the following limitations for Google Sheets – Up to 5 million cells for spreadsheets that are created in or converted to Google Sheets . 40,000 new rows at a time. Maximum number of columns of 18,278 columns. Assuming I stay within these limits how performant will be the app – Of course these constrains will be adhered to - https://www.glideapps.com/pro#summary
I want this to be duo lingual like the website. I have the transliteration for all 2M+ records between English and Unicode characters. Is there some kind of a global variable I can use to let users select/change their language of choice so that the app can look up the data from either appropriate columns or sheets with the language preferences
(Not directly related to glide) Are there any preferred solutions for MySQL -> Google Sheets synchronization?
Any other preliminary considerations I should be thinking of right now ?