# Glide Big Tables is now available!

**URL:** <https://community.glideapps.com/t/glide-big-tables-is-now-available/62009>\
**Category:** General\
**Created:** [May 22, 2023, 1:30pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009 "2023-05-22T13:30:39Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 25, 2023, 1:07pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/21 "2023-05-25T13:07:02Z")

</div>

> [@Darren\_Murphy](#):
>
> Actually, strictly speaking I don’t think this is correct 🤔

Ya…you might be right. I might have misunderstood a message from @Mark about GBT and it’s improved performance—might just be for API calls:

![CleanShot 2023-05-25 at 09.06.49](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0e5be61247283d49fc54d9859ddfd965b94b8dbe.png)

---

<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:** [May 25, 2023, 1:27pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/22 "2023-05-25T13:27:46Z")

</div>

> [@Martinus\_Goh](#):
>
> can i assume if the more computed column, the more resource need to be run in client devices ?  
> thats what make the app run slow ?

Yes, no, maybe.

There is no simple answer to that. Yes, computed columns consume client resources. But for 99.99% of uses cases the performance impact should be negligible.

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 25, 2023, 1:29pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/23 "2023-05-25T13:29:45Z")

</div>

Since i just migrated from Glide Classic Apps (Used GSheet and 4 different Table)

in Glide Apps, used glide table and merged 4 table into 1 since all of it related  
and most computed column also in 1 table,

i guess thats what make it so slow ?

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [May 25, 2023, 1:50pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/24 "2023-05-25T13:50:08Z")

</div>

I agree.

If now, we have to load a subset of data to work with it on App, the response speed will depend on our Query and how it was written. I mean, if I have a table with 40k registers (rows) and 50 columns, an inoffensive Query like this:

> Select \* from MyTable

will be slower and more inefficient than this:

> Select column1, column2, colum5 from MyTable Limit 25

I think that GBT and Firebase (GT) are column-oriented databases (NoSQL) so, our Queries have to be smarter and specific when those are written. We need to avoid the “brute-force searching for data” from now on.

Saludos!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [May 25, 2023, 2:27pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/25 "2023-05-25T14:27:39Z")

</div>

> [@gvalero](#):
>
> our Queries have to be smarter and specific when those are written. We need to avoid the “brute-force searching for data” from now on.

That’s a good habit to get into.

Selecting everything from a table works in development. Not so much for published apps. 😬

It’s like someone asking for a spoon, and you bring them the whole utensil drawer.

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 25, 2023, 2:38pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/26 "2023-05-25T14:38:21Z")

</div>

Hope the Glide Developer Notices This

I’ve been struggle to view the Table from Data and even from Layout (sometime even Not Responding) 🫠

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [May 25, 2023, 3:06pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/27 "2023-05-25T15:06:15Z")

</div>

> [@Martinus\_Goh](#):
>
> I’ve been struggle to view the Table from Data and even from Layout (sometime even Not Responding) 🫠

Are you using Big Tables? If so, start a thread in #glide-big-tables with more details.

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 26, 2023, 1:50am UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/28 "2023-05-26T01:50:38Z")

</div>

nope. im using only Glide Pro  
so maybe just normal glide table ? with only 25.000 limited row

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 26, 2023, 1:59am UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/29 "2023-05-26T01:59:23Z")

</div>

Just Came in Mind

Does Setting Row Owner make it grab query more efficiently ?

I Only used filter, because i want the file to be accessed dynamically when owner changed if wanted.

---

<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:** [May 26, 2023, 2:48pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/30 "2023-05-26T14:48:26Z")

</div>

How many rows are we talking about here?

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 26, 2023, 2:55pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/31 "2023-05-26T14:55:53Z")

</div>

right now nearly around 8000 rows

---

<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:** [May 26, 2023, 2:56pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/32 "2023-05-26T14:56:39Z")

</div>

Do you have a lot of calculated columns in your database? How many tables do you have in total?

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 26, 2023, 3:13pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/33 "2023-05-26T15:13:53Z")

</div>

8 Table

1 Table consist of more than 20 computed columns

---

<div class="post-metadata">

**Author:** ![grumo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumo/32/34786_2.png) [@grumo](https://community.glideapps.com/u/grumo)\
**Post date:** [May 26, 2023, 7:39pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/34 "2023-05-26T19:39:29Z")

</div>

They seem to work quite well. I did a test uploading a 125 MB CSV file with 1 million records to a Big Table. You can test it here → [https://bigtable.glide.page](https://bigtable.glide.page)

(It took 20 mins to import the 1 million records CSV file)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [May 26, 2023, 10:11pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/35 "2023-05-26T22:11:59Z")

</div>

hmm… google sheets are faster, thanks for sharing, now I know how BT performs 😉

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 27, 2023, 4:26am UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/36 "2023-05-27T04:26:53Z")

</div>

Used Glide Table (Not Big Table)  
it consumes a lot of time by loading the table with a lot of computed column (\>20) 😵‍💫

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 27, 2023, 4:28am UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/37 "2023-05-27T04:28:02Z")

</div>

yeah, i also think so.  
before i migrate to “only” glide table.

used gsheet, and loading time doesnt seems to be problem, sometimes slow but not too slow compared to my apps now (using glide table)

---

<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:** [May 27, 2023, 4:36am UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/38 "2023-05-27T04:36:09Z")

</div>

20 computed columns is not a lot. 20 computed columns is nothing.  
Of course it depends what those columns are doing, and how much data they are operating on.

But just to give you an idea, I have Apps with thousands of computed columns and they run just fine.

Take a look at the below to give you an idea of how powerful computed columns are, and how little they impact App performance:

> [@How would you describe a helper table?](https://community.glideapps.com/t/how-would-you-describe-a-helper-table/54497/16):
>
> @erwblo - I saw Bob Petitto mention something about golf last night… … which reminded me of one of my most “extreme” uses of a Helper Table. I have a Golf App that tracks scores in PGA Tour events, pulling in scores via an API every 5 minutes when an event is on. When the scores hit my App, they go into a table that looks like so: GolferID should be obvious, Raw is a comma separated list of their scores - 72 holes for a 4 round tournament. I use a 7…

---

<div class="post-metadata">

**Author:** ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)\
**Post date:** [May 27, 2023, 4:40am UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/39 "2023-05-27T04:40:48Z")

</div>

yeah, at first when on empty table or few record, slow loading doesnt felt at all  
back to my first app using gsheet with lot of computed column, also doesnt feel too much lag

but my new app with glide table only when i import in 7000record. it started loading slower than before

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [May 27, 2023, 12:59pm UTC](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009/40 "2023-05-27T12:59:34Z")

</div>

> [@Martinus\_Goh](#):
>
> right now nearly around 8000 rows

Hola!

Ok, 8k rows in 8 tables right? … and how many columns (real ones)?

The weight of your data is not defined only by the number of rows, the amount of columns also hits this. In short, your data and its load is based on the number of rows x columns you have created.

Bye

[Previous page](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009.md?page=1)

[Next page](https://community.glideapps.com/t/glide-big-tables-is-now-available/62009.md?page=3)
