malachydevlin

Speed of calculated field.

Discussion created by malachydevlin on Sep 23, 2015
Latest reply on Sep 23, 2015 by taylorsharpe

Hello All,

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.

Outcomes