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.
