I'm struggling with a calculated field on a list layout (50,000 records).
Basically its grinding the list view to a halt.
Unfortunately the client must have this field, its a field from a related table (via another table).
I've tried execute SQL in the calculation field and that's even slower.
I have the list view layout showing table a which has "id, reg_id, customer"
the reg_id is related to table b to its ID.
table b: id,brand_id.
table b is simply related to table c to pick up the brand_name (table c: id, brand)
So when i get the "brand" to display on table A it just crashes out.