# Joined Lists and Glide BIg Tables

**URL:** https://community.glideapps.com/t/joined-lists-and-glide-big-tables/81654
**Category:** Ask for Help
**Created:** [May 1, 2025, 7:03pm UTC](https://community.glideapps.com/t/joined-lists-and-glide-big-tables/81654 "2025-05-01T19:03:24Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### 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: [May 1, 2025, 7:03pm UTC](https://community.glideapps.com/t/joined-lists-and-glide-big-tables/81654/1 "2025-05-01T19:03:24Z")

</div>

Day 6 of working with Glide Big Tables:

In dev I have a 1,000 entry table matched against a 2,500 table. In production I expect to have a base table (\>10,000 entries) which I match against a table which could have upward of 200,000 entries. Both tables are pre-processed so I can create Basic columns out of many of the Glide columns that are currently Lookups, etc.

I have tried to move this to a Big Table but run into the 100 limit (especially for Joined Lists and but can work around most lookups) as well as not being able to create joined lists of certain joined lists (one was an array and the other was a query into a big table returning a joined list).

Not sure why the 100 limit is so low or if it is expected to change to a bigger number (or go away) in the future.

Not sure what others are doing to work around these limits. I can’t be the first.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a4cb72463d53e28dbbd0491914db39b0b4fa514.png)

---

<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 2, 2025, 12:24am UTC](https://community.glideapps.com/t/joined-lists-and-glide-big-tables/81654/2 "2025-05-02T00:24:28Z")

</div>

> [@MattLB](#):
>
> Not sure why the 100 limit is so low or if it is expected to change to a bigger number (or go away) in the future.

We have no assurance of this being changed to a considerable bigger number in the future.

> [@MattLB](#):
>
> In dev I have a 1,000 entry table matched against a 2,500 table

When you say “matched against” here, do you mean a relation?

---

<div class="post-metadata">

### 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: [May 2, 2025, 12:30am UTC](https://community.glideapps.com/t/joined-lists-and-glide-big-tables/81654/3 "2025-05-02T00:30:01Z")

</div>

Relation or query depending. But yes.