Glide Big Tables – Better than Glide (Regular) Tables?

[MaximeBaker]

Here a thread that you read:

When to go in for Big Tables?

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 into Big Tables (eg. Lookups via Multiple Relations or Lookups that target an entire Big Table column)
• Rollups are supported on Math, Template, and IfThenElse columns 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 data source.
• Computed columns are limited to 100 rows.
• Computed columns cannot be used as filters in a Big Table.