Clarification on Glide Row Limits and Big Table Usage

[y09a16]

I am currently using the Maker plan and managing a system to track the monthly status of a product. Each month, about 4,000 new rows of data are added, and these are stored in Glide Big Tables. Since I have only been running this for a few months, the total is around 20,000 rows so far.

I noticed the description “Up to 50k” and became uncertain about its meaning. From what I understand, the “Rows” shown on the Glide Usage page refer only to rows outside of Big Tables. Therefore, the 50k row limit applies to sheets and other data sources, while Big Tables can store a much larger number of rows.

Is my understanding correct, or am I mistaken?

[Darren_Murphy]

You are mistaken.

You can have up to 25,000 rows in regular data sources (Glide Tables, Google Docs, etc) and up to 50,000 rows in Glide Big Tables, per app.

Although Glide Big Tables can store many more rows, they are capped at 50k on the Maker plan.

[y09a16]

Thank you for your previous answer.
I have three additional questions:

1. Is it correct that I can use up to 25,000 rows in regular tables plus 50,000 rows in Big Tables, for a total maximum of 75,000 rows?

2. I am currently storing past data in Big Tables. If the row count exceeds 50,000, will I start to experience performance issues, such as slower operation?

3. As an option to archive past data, are there any recommended approaches? At the moment, I am considering moving to the Business plan and using the API to migrate data as needed, but from a running-cost perspective, I am struggling because I would prefer to stay on the Maker plan.

[Darren_Murphy]

@y09a16

Is it correct that I can use up to 25,000 rows in regular tables plus 50,000 rows in Big Tables, for a total maximum of 75,000 rows?

Yes

@y09a16

I am currently storing past data in Big Tables. If the row count exceeds 50,000, will I start to experience

Once you hit 50,000, you won’t be able to add any more rows.

@y09a16

As an option to archive past data, are there any recommended approaches? At the moment, I am considering moving to the Business plan and using the API to migrate data as needed, but from a running-cost perspective, I am struggling because I would prefer to stay on the Maker plan.

One option would be to export older data as CSV, and store it elsewhere.

[y09a16]

Thank you again. I have one more question.

With the Maker plan, I understand that I can publish up to three apps. My question is: do the row limits (25,000 for regular tables and 50,000 for Big Tables) apply as a combined total across all apps (including unpublished ones), or are the limits applied separately to each app?

[ThinhDinh]

@y09a16

With the Maker plan, I understand that I can publish up to three apps. My question is: do the row limits (25,000 for regular tables and 50,000 for Big Tables) apply as a combined total across all apps (including unpublished ones), or are the limits applied separately to each app?

It’s per app.

[Darren_Murphy]

@y09a16

or are the limits applied separately to each app?