Hi all, One pic to explain the problem: [image] Surprisingly (or not), the app is still semi-functional. The majority of these ~73K rows are activity rows. These are rows that refer to a specific interaction with a client. On the upside, our team is rather meticulous and have excellent logging e…

That’s a pretty high level question and really depends on your particular situation, but generally, if you have an array, you can use a Joined List column to convert it to text. Then using a set column action you can write it wherever you need to. Later, a Split Text column will convert it back to…

[image] Jeff_Hager: if you have an array, Are we talking about these columns? https://www.glideapps.com/docs/reference/basic-columns/array-columns If so, I’m not sure I understand how to use this. [image] Jeff_Hager: depends on your particular situation I’d like to have all data ins…

[image] Test_Test: Are we talking about these columns? I’m talking about any array, regardless of how it was created. A single value is a single value. An array is a collection of multiple single values. There are several different ways to end up with an array, but they are pretty easy to …

Wow, thanks. Very detailed and mind opening. [image] Jeff_Hager: Then you can create a relation to link that array to a projects table. Could you please explain which type of table are you referring to here? Is it a general table for “project types”? [image] Jeff_Hager: How much data is…

[image] Test_Test: Could you please explain which type of table are you referring to here? Is it a general table for “project types”? I’m talking about creating those three columns in the Clients table (Basic Text, Split Text, and Relation). I’m assuming you have a Clients table as well as a…

[image] Test_Test: Thanks Jeff. As always, a delight to read your detailed reposes. Indeed!

Thanks for the truly positive and supportive attitude. Everyone in my organization can tell you that I’m a true advocate for Glide from the moment I started using it. They can also tell you that I’ve lost this passion for Glide over the last few months. [image] Jeff_Hager: They are probably ca…

Regarding your concerns about IMPORTRANGE, it can be a viable option if implemented carefully. You can have a separate sheet for archived data and use IMPORTRANGE to fetch it when needed. However, be mindful of potential performance impacts. Using the Glide API could be a more advanced solution but…

I don’t see the 25,000 row limit as the dark side, but I do need to address my row count and I could use some expert advice on which way to proceed. Soon… :fearful: Notes Business plan Transactional data, always adding rows New data comes into the app via Zapier as well as within Glide. Since the…

I’ve never grown an app to 25k+ rows, so I don’t speak out of experience. But I’m trying to put myself in your shoes. Here would be my thought process. [image] HeartwoodTreeCo: Transactional data, always adding rows This leads me to think that you’ll blow through 25k rows no matter what you …

Row limits - The dark side of Glide :)

Ask for Help

Darren_Murphy April 25, 2024, 7:09am 40

Also see below for a bit of general advice on migrating from regular tables to Big Tables:

Topic		Replies	Views
Glide Big Tables - pricing Ask for Help big-tables	56	1864	January 18, 2024
Are there any other sites like Glideapp? Ask for Help	49	1762	February 5, 2021
25k row limit workaround Ask for Help	15	123	February 20, 2026
Any suggestions to have more rows beyond 25000? Ask for Help	11	1876	March 8, 2022
How scalable is Glide Ask for Help	42	12385	January 12, 2024

Row limits - The dark side of Glide :)

Related topics