I am facing performance issues in the app that I am developing. Once a user enters data using the ‘+’ button, the time taken for Glide to reflect data in my app is nearly 20 seconds now compared to what it was initially (4 seconds). The number of rows is nearly 250 now. Everyday, around 10 rows gets added up. The sheet has about 23 tabs. (All these tabs does it’s own processing).
I do have a lot of ARRAYFORMULA and other logics working.
Sometimes, I have to go to Glide builder and do the “Reload Sheet” to get data refreshed on front end.
Are there any Performance Enhancement tips that we can use while designing the Google Sheet framework?
It will be great if we can have a Do’s and Don’ts wiki kind of list that we can refer.