Glide Big Tables | Bad performance

[Faris_Ben_Saad]

Hey Gliders,

Just some Context:

• We had an Airtable-only Backend for our application so far.
• The application is very feature-rich and has several queries (we’re already optimizing on that)
• despite the application being a little slow in the Glide Dev portal it’s still fast in the Live portal for our clients
• because of several sync issues related to Airtable we decided to switch to Glide Big Tables for new features

Problem:

• After implementing a new feature with 2 new Glide Big Tables (currently with about 30-300 rows) our whole application got very very very slow in the Glide Dev. Environment.
• And for the first time ever the new feature that is based on Glide Big Tables is so god damn slow in the Live portal that you can barely use it.

Details on the new feature:

• It’s a table with about 10 columns displaying rows from an Airtable T1
• Each entity in T1 (= WorkerPlacements) has a 1:1 relation to an entity in a Glide Big Table T2 (SignatureRequests)
• The table has 2 columns with one action button each to do sth. with an entity from T2, e.g. For each Worker the user can create a SignatureRequest
• For the action buttons a Worker references to it’s SignatureRequest
• If one action button is clicked it takes 20-50 seconds until another button can be clicked and everything feels very slow.

Question:

• Did anyone have experiences with slow Glide Big Tables so far and can give some advice?

[slscustom.ru]

Hi!
Firstly try to check Performance Analysis to determine which computed column take a long time to calculate

[Faris_Ben_Saad]

So, I tried to clean everything up. Only kept the very crucial things and that’s what I found:

1. The 2 Glide Big Tables seem to have sufficient performance (marked green )
2. The look up fields in the table Placements T1 have a bad performance (marked red ) - but relative to other columns the performance should still be good enough.
3. Despite that the application using the Glide Big Tables didn’t get faster. It’s so slow we even have clients that complained about the performance.

I already tried it with single value instead of lookup but that didn’t change anything.

Are Glide Big Tables not supposed to be used in other tables?

[ThinhDinh]

How are those lookups configured? I assume it’s on top of a relation/query?

[Faris_Ben_Saad]

Hi @ThinhDinh,
yes they’re are configured on top of this conditional relation:

[gvalero]

These tips can be useful for you:

App Performance Tips & Tricks: SPEED!

Tabs can have a benefit in some cases because some tables may not run computed columns until necessary. Less content on a page can have a benefit as there is less to render. I really don’t think this has an effect. I think the largest speed issues will depend on how your data is structured. Any computed columns that rely on the values of computed columns in multiple other rows will have a large impact. Ask yourself this question…will displaying something on a screen require multiple rel…

I was going to suggest 2-3 ideas but the Jeff’s tips already covered all this

I hope it helps you!