# Big Table Limits

**URL:** <https://community.glideapps.com/t/big-table-limits/74385>\
**Category:** Ask for Help\
**Created:** [June 26, 2024, 6:32am UTC](https://community.glideapps.com/t/big-table-limits/74385 "2024-06-26T06:32:38Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\
**Post date:** [June 26, 2024, 6:32am UTC](https://community.glideapps.com/t/big-table-limits/74385/1 "2024-06-26T06:32:38Z")

</div>

Are there any good resources explaining clearly how big tables work & are priced & are loaded?

There are some questions that seem to be a bit confusing:

- How are big tables loaded (row count, starting from top or bottom etc…)
- Are we allowed 10 million rows all big tables combined or per big table
- Do big tables reduce the performance/speed of an app on a user device lets say an app is connected to 5 big tables each are 1 million rows.
- What is the best way to backup big tables once we reach the 10 million mark ? is the data downloadable or is there any good advice where to take it?
- Do users put big table data in charts, what is the price of doing so, what are the limitations of doing so …etc.

Appreciate any input on Big Tables here.

---

<div class="post-metadata">

**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\
**Post date:** [June 26, 2024, 5:10pm UTC](https://community.glideapps.com/t/big-table-limits/74385/2 "2024-06-26T17:10:38Z")

</div>

and i thought big table was THE data source Glide supported the most …

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 26, 2024, 11:30pm UTC](https://community.glideapps.com/t/big-table-limits/74385/3 "2024-06-26T23:30:39Z")

</div>

I’m curious, what makes you think this? Without any limitations on computations, I would have thought normal Glide Tables would be that one.

---

<div class="post-metadata">

**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\
**Post date:** [June 27, 2024, 3:39am UTC](https://community.glideapps.com/t/big-table-limits/74385/4 "2024-06-27T03:39:40Z")

</div>

Wasn’t it mentioned somewhere here that big table are the future of glide tables

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 27, 2024, 4:06am UTC](https://community.glideapps.com/t/big-table-limits/74385/5 "2024-06-27T04:06:33Z")

</div>

It might actually be, but at the moment the statement that Glide supports Big Table the most is not correct in my opinion.

---

<div class="post-metadata">

**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\
**Post date:** [June 27, 2024, 4:15am UTC](https://community.glideapps.com/t/big-table-limits/74385/6 "2024-06-27T04:15:25Z")

</div>

Yes obviously its not correct … as you can see it has been hard to get any answers to some simple big table questions.

Even the ‘reload query’. Seems hard to know how many updates that would incur if added to an action.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 27, 2024, 4:21am UTC](https://community.glideapps.com/t/big-table-limits/74385/7 "2024-06-27T04:21:52Z")

</div>

> [@abdo](#):
>
> Yes obviously its not correct … as you can see it has been hard to get any answers to some simple big table questions.

Yeah, I’m just as curious as you. Maybe @Darren_Murphy has more experience than any other in this regard.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 27, 2024, 4:26am UTC](https://community.glideapps.com/t/big-table-limits/74385/8 "2024-06-27T04:26:13Z")

</div>

> [@abdo](#):
>
> How are big tables loaded (row count, starting from top or bottom etc…)

Just based on observation, the first 1000 rows are loaded, and then other rows are loaded as required.

> [@abdo](#):
>
> Are we allowed 10 million rows all big tables combined or per big table

My understanding is that 10 million rows is a “marketing” limit. In practice, you can have as many rows as you want.

> [@abdo](#):
>
> What is the best way to backup big tables once we reach the 10 million mark ? is the data downloadable or is there any good advice where to take it?

I’ve not tried it, but I would expect that CSV export will work no matter how many rows there are.

> [@abdo](#):
>
> Do users put big table data in charts, what is the price of doing so, what are the limitations of doing so …etc.

A chart is just a different type of collection, so the same limitations apply around computed column types. Other than that, Big Tables work fine as the source of a chart.

> [@abdo](#):
>
> Even the ‘reload query’. Seems hard to know how many updates that would incur if added to an action.

Each reload is one update.

---

<div class="post-metadata">

**Author:** ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)\
**Post date:** [June 27, 2024, 4:34am UTC](https://community.glideapps.com/t/big-table-limits/74385/9 "2024-06-27T04:34:57Z")

</div>

Thank you so much @Darren_Murphy

We are in the process of putting Order history data into Big Tables.

That would mean 3 big tables

- Orders
- Items (OrderID included)
- Bookings (ItemID included)

Its a bit challenging to understand the costs involved and the best design taking into consideration that user device performance is very very important for us as its our major problem using Glide for our operations team.
