Catalog form is loading very slow when using select look up box

[Shaik Noorulla]

Catalog form is loading very slow when using select look up box, Please explain Why?

[Brad Bowman]

The query for the Lookup Select Box has to run every time as/before the form loads.  The larger your Lookup from table, the longer this will take, depending also on the reference qualifier, and Unique values only. 

[Shiva Kumar2 · Accepted solution]

one of the common reason for form loading very slow is it contains look up select fields.  if the field is choice its better to select the choices from sys_choice instead of record table.

Please see below screen shot