Page 1 of 1

Edit a record is slow if there are a lot of lookup tables

Posted: Fri Jun 17, 2022 2:13 am
by Andros

I have a table with records containing 30 fields with lookup table.
Whe I try to edit the record it is very slow, and I need to make it faster. Any idea?


Re: Edit a record is slow if there are a lot of lookup tables

Posted: Fri Jun 17, 2022 7:49 am
by MichaelG

You can enable lookup cache for the table in the Page_Load server event. For example:

SetUseLookupCache(true);