# Big Table Q&A

**URL:** https://community.glideapps.com/t/big-table-q-a/60037
**Category:** Ask for Help
**Tags:** big-tables
**Created:** [April 2, 2023, 3:56pm UTC](https://community.glideapps.com/t/big-table-q-a/60037 "2023-04-02T15:56:59Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [April 2, 2023, 3:56pm UTC](https://community.glideapps.com/t/big-table-q-a/60037/1 "2023-04-02T15:56:59Z")

</div>

Big Tables have the potential to unlock a vast amount of power for our apps. What ways have you come up with to use a Big Table in your app?.. future plans? Personally I’d like to query a Big Table from another Glide Table (similar to using a filter in GoogleSheets or how BigQuery works in Glide)

 ![Screen Shot 2023-04-02 at 12.10.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/1068002bbb94198043713f349fa2d74080824842.png)

Are there any plans to be able to query a Big Table like in the example above☝️? I received this error message when trying to setup a relation. I understand relations aren’t supported yet but it seems to indicate a query is or will be available near future.

 ![Screen Shot 2023-04-02 at 11.48.21 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/86f07542e2ec36294bd4ba28dff108941d9d7951.png)

> **[Big Tables](https://www.glideapps.com/docs/essentials/data-sources/big-tables)**
>
> Scale your app with up to 10 million rows of data.

---

<div class="post-metadata">

### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 2, 2023, 4:42pm UTC](https://community.glideapps.com/t/big-table-q-a/60037/2 "2023-04-02T16:42:58Z")

</div>

Relations are supported, but not to computed columns.

---

<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: [April 2, 2023, 8:53pm UTC](https://community.glideapps.com/t/big-table-q-a/60037/3 "2023-04-02T20:53:49Z")

</div>

Hola @Eric_Penn

I would use the _Limit_ parameter as a good practice to reduce the amount of data received and improve the response time of SQL queries.

E.g., here the query as soon as it finds the first 20 items will return a valid response and won’t keep searching the entire database which might be over 150k+ records.

> SELECT \* FROM MyContacts  
> WHERE age \> 25  
> ORDER BY LastName ASC  
> LIMIT 20

Saludos!