What I’m trying to do: I have four tables: Customer Has around 4500 rows Status (Linked in Customer) Has 10 rows Location (Linked in Customer) Has same amount of rows as Customer (4500) Country (Linked in Location) Has around 15 rows Customer and Location are “1-to-1”, meaning a Cust…

You really should be allowing the database to filter, not doing so in a list comprehension. Avoid fetching everything and filtering yourself unless you absolutely cannot do the filtering using db features. In your case, you can filter based on the linked field by looking up the linked rows, e.g. (…

Optimizing search with multiple linked rows

Anvil Q&A

anthonys June 30, 2022, 8:16pm 2

Just checking, but do you have accelerated tables checked?

That’s a quick & easy change , if not implemented and a HUGE speed bump.

1 Like