I have been working with glide for about 2 years.
My biggest job with glide has registered over 100k users and now I’m worried about what will happen to my app because there is too much data inside.
Is it possible to speak to a glide expert to understand how I can prevent the damage?
There’s an old trick I used to use when I was using Glide regularly. You can use a separate google sheets workbook to store data. in that workbook you have a page pull the data you need to lookup into it. Then the workbook thats not associated with glide will run its lookup with that data and return just the results you need. And finally in your glide associated google sheet it does the same thing and as the other sheet and has a page that equals the resulted query.
Or you can run a script to export the JSON of the non associated sheet and use that as a Query in Glides sheets to pull the data in a similar manner.