Using glide tables with large data

[moshetwitofit]

Hey people!

TL;DR
App is deadslow, using google sheets with 50k rows+
Moving to glide tables will run the app smoothly?

Fulll story:
I have a glide app using google sheets,
I have a fitness app which my client use to follow thier diet & fitness plan,
A part of it is the upload your daily weight & selfie.

Skipping forward, the weights sheet is getting too big, (50k rows)
And getting bigger all the time,
I have many more sheets for the diets, fitness plans and so on,
But all the other sheets have 1 row for each client (a few hundreds).

The app is dead slow, a submit from glide to sheets takes raughly 5 mins ()

My question is,
If I will use glide tables instead of sheets,
Would it be enough to run my app smoothly?

BTW
Im already using user based data, users download only thier relevant data.

Thanks!

[ThinhDinh]

@moshetwitofit

Im already using user based data, users download only thier relevant data.

So I assume you’re already using “row owners”, right? How many rows would a user download on average with that setup?

The threads below may give you more info on Glide Tables vs Google Sheets.

When is a glide app "too big"?

Caveat: Please take everything I say here with a grain of salt. I’m only speaking from my own experience, and bits of information that I’ve been able to glean from various other folks. Yes, I believe there is a hard limit on the size of an app. As you suggest, it has nothing to do with row count, but is more a function of how complex the app is and how much file space it occupies once it’s all bundled up. I have an app that’s been skirting the limit for a while now. A month or so ago, I split …

What's the difference between Sheets and Tables?

The data will be stored the same whether you use a glide table or a google sheet. The only difference between the two is that there is the extra step of the data having to sync between glide and google. They both function the same otherwise. The only time I use google sheets, is when I need the data in the Google sheet to work with it in a way that I can’t when it’s in a glide table. All data for everyone will store in the same table. I would make sure you have an email column in the data, …