Good question @Rasha, I have seen this kind of discussion before and I put my opinion here:
1- if you need results in real-time such as a quotation, a math calculation, etc I could load the whole data because it will be must within Glide
2- If you need only a static value which does not change very fast, it is a stats and/or is part of a huge data, I’d rather to have it in GS, create my key values there and keep my app light by avoiding unnecessary data.
E.g: the data associated to a small town with 20.000 persons to know its average age, male/female stats, oldest person name, etc.
Why load 20k rows to APP when all these values can be done and save in GS using simple formulas (or maybe, some Query() function)?
Doing this, you could load few data (1-2 rows with 3-5 columns) and everything will be easier to maintain and faster to load.
It’s not necessary to use always brute-force and let Glide or any software makes the heavy job. GS is a powerful tool and you need to know when and how to use it, Glide’s Data Editor can’t defeat it most cases.
Feliz noche Rasha.