500 Row Limit - What Counts?

@Eric_Penn

Glide does not count empty rows, it’s been asked a few times

4 Likes

Right, as long as the rows are referenced in the app or the tab is referenced in the app. I have a workbook with over 50k rows in it and the app shows 1k rows used because I use vlookup to pull from those 50k rows.

3 Likes

That’s incredibly useful to know.

Dumb question: Are the rows in glide sheets also counted to the total?

yes, they are. (although I would assume that if you unlink a Glide table, then it no longer counts)

1 Like

Sorry for the delayed reply, appreciate the responses! Still need a bit of clarity though. Here is the post I referenced when first starting to make my app:

But this isn’t quite true now, correct? I don’t have the users of my app displayed within the app, I only reference them for tab visibility purposes.

@Drearystate thanks for this - sorry to say I actually don’t know what vlookup or hlookup is :grimacing:
(My sheet only has one formula and it’s only to convert emails to lowercase - I copied it from these wonderful forums)
I do have relation columns in my app, my biggest confusion is that I’m very certain my User Profile sheet rows were NOT counting when I first published the app to test it. At that time there was one relation column gathering info into the User Profile sheet from another sheet. However I’ve created a few additional relational columns since then (I’m fuzzy on which ones happened when) Does it matter which direction the relation columns come from? If I have a relation column drawing info FROM the User Profiles sheet, is that when the row count gets activated? Or is it a two-way street and maybe I just encountered a bug where the row counts weren’t updating for me in the moments I was testing it :thinking:

Not at all a dumb question! My sheet in question is a Glide sheet, and it switched from rows not being counted to suddenly being counted :woman_shrugging:t2:

Yes, this is the response I’ve seen before. I was looking to define “used” as my Glide sheet which captures login emails and onboarding (none of which is displayed within the app) was not initially being counted, unless that was a temporary bug in the row count tracker. In other words - if a hypothetical Glide user built an app from a sheet with 50 rows but then incredibly acquired 50,000 users of their little app - would their row count then be 50,050? Do all users that are logged to a sheet count as rows?

1 Like

Hi @a.manda,

It is my understanding that if rows are in any way connected to the app, say relations, lookups etc etc. they will be counted whether they are hidden or not.

You mentioned you have your user tab hidden but have a relation to that tab. In this case, Glide will count those rows because the relation connects it to the app.

I hope this sheds some light.

1 Like

This is correct. Any rows not shown but used to reference something are still counted.

2 Likes

@SantiagoPerez @ThinhDinh does it matter which direction the relation is headed? I only ask because when the rows were NOT being counted I did already have one relation enacted - where the user profiles sheet was referencing the member directory to see if the logged in user was also listed on the member directory (wherein they would be able to edit their directory profile)

If it does not matter in which direction the data is flowing then I have to assume there was a bug happening for me when I thoroughly tested the app at this point and my row count was not affected by adding users to the user profile sheet. This was the beginning of ALL my confusion :neutral_face:

I would say it does matter. I don’t usually refer or relate to data that is hidden so I could not say if it was a bug or that is the expected behavior.

Maybe @ThinhDinh has seen this case before.

I think everything that is used in the app will always count. If @a.manda can replicate that and have a video then we would know better. I can’t seem to replicate it now.

1 Like

I would agree. Regardless of relation direction or how you use it. If glide needs to refer to that sheet data in ANY way, it should be counted against your row count. If you were add a sheet, fill it with a bunch of data, and never use it for anything within glide, only then would it not count. What you experienced most likely was a bug. Long story short…if your app is doing anything with the data in a sheet (displaying or relating), it should count the rows in that entire sheet.

2 Likes

I’m telling you that if you use a vlookup it doesn’t count. Glide has no way to indentify a vlookup formula. Let me show you some pics

This is my current row count

image

This is the last row of that same google workbook

My 6k rows are all vlookups for user logins, people that have yet to login or probably never will are in that 29k row. So, tell em now how Glide sees those?

2 Likes

Here’s the thing, Glide is only working with the data the vlookup pulls, not the data it doesn’t that’s why it doesn’t count. I will make a template with the 500 row count so you guys can see and I will use 10k rows for it.

2 Likes

You are correct regarding this, it’s no problem using a VLOOKUP or a HLOOKUP but Amanda was referring to a relation inside Glide so if those rows are not counted then it’s a bug.

I’m not sure how much delay it would introduce to use a Vlookup on a big set of data instead of a relation as well.

2 Likes

If the vlookup is pulling from her entry in glide the delay with all sheets closed is about 19 seconds

2 Likes

@ThinhDinh I am curious enough that I might - when I have time - try to recreate my app up to the point where I first tested the row counts!

@Jeff_Hager it’s just occurring to me that all my testing of row counts took place before that major update of Glide’s sheets that you had told me about - the very update that fixed all my tab visibility issues. Glide sheets are still a bit buggy but 1000x better than they were! I’m guessing my lack of rows being counted was related to their previous-very-buggy state :flushed:

@Drearystate my relations are all within Glide. I’m not advanced enough - though hopefully someday will learn - to use formulas like vlookup and hlookup. Since there appears to be the result of a delay I probably won’t explore them here, but I will refer back to your reply later so that I can learn how they work! Also thank you for validating my point that “rows used in your app” is too simple an answer for curious minds :blush:

2 Likes

Now thats a reply.

1 Like

Sorry to go off topic, but do all formulas in Google sheets cause a delay, or only ones like this Vlookup? I ask because I put a column into my Google sheet that’s simply a lowercase conversion formula, and ever since then my app takes five full seconds to load instead of the immediate load it had before. (I have a relation within Glide to this lowercase column too) I had made several changes at once in addition to this one before the delay occurred so I’ve been avoiding the nightmare of trying to track down the culprit! Are formulas a main suspect?

The delay is in Glide really, so when you send/enter new data it just has a delay to refresh its data,you would see the data in your sheets within seconds, the formula is instant its just how long glide looks back at the data again. Glide says they refresh the data every minute or upon data being edited. The problem with this is a fornula result changing isn’t considered a sheet edit, it’s considered a sheet change. And Glide only updates on a sheet edit and every minute. With that being said, when google sheets are closed and you are using formulas for returned values it actually takes about a 3rd of the time.

1 Like