# Glide Big Tables – Better than Glide (Regular) Tables? **URL:** \ **Category:** General\ **Created:** [December 18, 2024, 4:30pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680 "2024-12-18T16:30:56Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 18, 2024, 4:30pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/1 "2024-12-18T16:30:56Z")
I see that the option to choose a glide table when choosing a data source is no longer there. But glide Big Tables is on offer. I assume glide tables are the default and big tables is where things are headed. Can anyone give some clarity on the capabilities of big tables. Is it at least capable of doing what glide tables can do, can we use computed columns with big tables. Any updates would be appreciated. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [December 18, 2024, 5:15pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/2 "2024-12-18T17:15:40Z")
Here a thread that you read: > [@When to go in for Big Tables?](https://community.glideapps.com/t/when-to-go-in-for-big-tables/71730/2): > > I have worked a lot with Big Tables right from the start, so I feel like I can share a few things that I’ve learned. My general rule of thumb is that I only use Big Tables for transactional type tables, where lots of rows are being added on a regular basis. If I expect the row count to climb above around 10k within a year, then I’ll definitely use a Big Table. When opting to use a Big Table, you need to think carefully about how it will be used, and how it will interact with other tables in yo… Limitations of Big Tables There are some features in Glide that aren’t compatible with a Big Table. These unavailable features are: - Some Single Value columns that target Big Table columns. - Multi [Lookups](https://www.glideapps.com/docs/lookup-column) into Big Tables (eg. Lookups via Multiple Relations or Lookups that target an entire Big Table column) - [Rollups](https://www.glideapps.com/docs/rollup-column) are supported on [Math](https://www.glideapps.com/docs/automation/computed-columns/math-column), [Template](https://www.glideapps.com/docs/automation/computed-columns/template-column), and [IfThenElse columns](https://www.glideapps.com/docs/automation/computed-columns/if-then-else-column) only, and only if those columns target basic columns. - The Delete Rows action cannot be applied through a multi-relation in Big Tables. - A Big Table cannot be the [User Profile](https://www.glideapps.com/docs/user-profiles) data source. - Computed columns are limited to 100 rows. - Computed columns cannot be used as filters in a Big Table. ---
**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:** [December 18, 2024, 6:09pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/3 "2024-12-18T18:09:30Z")
> [@MaximeBaker](#): > > There are some features in Glide that aren’t compatible with a Big Table. These unavailable features are: > > - Some Single Value columns that target Big Table columns. > - Multi [Lookups](https://www.glideapps.com/docs/lookup-column) into Big Tables (eg. Lookups via Multiple Relations or Lookups that target an entire Big Table column) > - [Rollups](https://www.glideapps.com/docs/rollup-column) are supported on [Math](https://www.glideapps.com/docs/automation/computed-columns/math-column), [Template](https://www.glideapps.com/docs/automation/computed-columns/template-column), and [IfThenElse columns](https://www.glideapps.com/docs/automation/computed-columns/if-then-else-column) only, and only if those columns target basic columns. > - The Delete Rows action cannot be applied through a multi-relation in Big Tables. > - A Big Table cannot be the [User Profile](https://www.glideapps.com/docs/user-profiles) data source. > - Computed columns are limited to 100 rows. > - Computed columns cannot be used as filters in a Big Table. I realise that list is lifted directly from the [docs](https://www.glideapps.com/docs/essentials/data-sources/big-tables#limitations-of-big-tables), but the docs are somewhat out of date, and some of those points are quite misleading. Specifically: > [@MaximeBaker](#): > > Some Single Value columns that target Big Table columns. A Single Value column that directly targets a Big Table will not work. But a Single Value column that targets a Big Table via a Multiple Relation or Query _will_ work. However, only Single Value-\>First is supported. > [@MaximeBaker](#): > > Multi [Lookups](https://www.glideapps.com/docs/lookup-column) into Big Tables (eg. Lookups via Multiple Relations or Lookups that target an entire Big Table column) Lookups via Multiple Relations and Queries _are_ supported, but limited to the first 100 matching rows. > [@MaximeBaker](#): > > [Rollups](https://www.glideapps.com/docs/rollup-column) are supported on [Math](https://www.glideapps.com/docs/automation/computed-columns/math-column), [Template](https://www.glideapps.com/docs/automation/computed-columns/template-column), and [IfThenElse columns](https://www.glideapps.com/docs/automation/computed-columns/if-then-else-column) only, and only if those columns target basic columns. Rollups (and Joined Lists) are actually supported for most computed column types, but limited to the first 100 matching rows. For example, a Joined List of a JavaScript column will work perfectly fine. > [@MaximeBaker](#): > > Computed columns are limited to 100 rows. This is misleading. It gives the impression that computed columns will only be calculated for the first 100 rows, which is of course incorrect. Where the 100 row limit comes into play is when you try to _aggregate_ computed columns, eg. via Rollups or Joined Lists (see my comments above). NB. All of the above assumes that the “More computed column support for Big Tables” preview feature is enabled. ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 18, 2024, 7:07pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/4 "2024-12-18T19:07:42Z")
Thanks for this, this helps a lot👍 ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [April 9, 2025, 7:31pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/5 "2025-04-09T19:31:46Z")
I had a short and eye-opening talk with @tuzin.arts today about Glide Big Table. I’ll rephrase what I understood (my apologies, Art, if I misunderstood anything): 1. By default he will build on Glide Big Tables and not on Glide (Regular) Tables 2. If a table will expand in terms of number of rows, even if it’s a few rows every so often, he will use a Glide Big Table 3. He will only use a Glide (Regular) Table for helper tables which have a fixed number of rows 4. Glide Big Tables forces us the developer to build cleaner I’ve stayed clear from Glide Big Tables because in general I am more comfortable staying away from the edges of experimentation. For a long time, I’ve felt that GBTs were still in the prototype and testing phase, and not yet a product I would be comfortable building on, certainly due to my own limitations. But Art’s comment made me wonder: is it now time to make the switch and to seriously (for me) start building on Glide Big Tables? If so, would I use GBT for all tables like Art does it – except for the Users table and helper tables – or would the adoption of Glide Big Tables be more nuanced, such as suggested by Darren below (transactional tables, chat)? Thanks in advanced for any insights and personal experience you might be able to share. * * * > [@When to go in for Big Tables?](https://community.glideapps.com/t/when-to-go-in-for-big-tables/71730/2): > > My general rule of thumb is that I only use Big Tables for transactional type tables, where lots of rows are being added on a regular basis. If I expect the row count to climb above around 10k within a year, then I’ll definitely use a Big Table. ---
**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:** [April 9, 2025, 11:46pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/6 "2025-04-09T23:46:54Z")
> [@nathanaelb](#): > > is it now time to make the switch and to seriously (for me) start building on Glide Big Tables? Not until I see less challenges in building computation columns around it, but that day may come soon. At the moment, there’s too much hopping around we have to do to be able to build a working app with solely Big Tables. I don’t see a reason why you have to go for Big Tables first if you understand your usage won’t go that high. ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [April 12, 2025, 2:58pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/7 "2025-04-12T14:58:09Z")
But the 100 row limit for RollUps make Big Tables nearly worthless as the source for dashboards / totals. Or am I missing something ? TIA ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [April 12, 2025, 3:35pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/8 "2025-04-12T15:35:48Z")
> [@MattLB](#): > > RollUps RollUps not limited to 100 rows in GBT Lookups and joined list from GBT limited to 100 results ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [April 12, 2025, 3:53pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/9 "2025-04-12T15:53:00Z")
As described above GBT forcing as to develop not like in Google sheet but like DB. When you create in GT, you don’t have to explore to advance and develop step by step. But very quickly your app became like a common GS - slow. With GBT you need explore, investigate, design, redesign and then to build and rebuild. And this takes much more time to build(edit) an app. But the result you can create very complex and fast app if need. I think. ---
**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:** [April 13, 2025, 2:05am UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/10 "2025-04-13T02:05:14Z")
> [@MattLB](#): > > But the 100 row limit for RollUps make Big Tables nearly worthless as the source for dashboards / totals. Or am I missing something ? Yes. You are. ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [April 24, 2025, 2:44pm UTC](https://community.glideapps.com/t/glide-big-tables-better-than-glide-regular-tables/78680/11 "2025-04-24T14:44:07Z")
Moving from google to sheet to GBT. In regards to a RollUp (count) - if the filter returns 257 items in a Glide Table the count is 257. Would the same result in a GBT be 100? I use count/sum/average to present weekly/quarterly/yearly info. TIA