Question

Search Custom field response very slow

  • 18 January 2023
  • 5 replies
  • 33 views

Userlevel 5
Badge +7

How can I solve this issue?

 

Regards;

Yasuda

 


5 replies

Userlevel 7

Can you provide some more information? Where are you searching? What type of custom field is it? Which version of the application? 

Userlevel 5
Badge +7

Field type is read only and IFS APP10 upd13.

Regards;
Yasuda

 

Userlevel 5
Badge +7

Any update??

 

Regards;
Yasuda

Userlevel 6
Badge +14

Searching on read only custom fields in LU’s with large amount of total records is not recommended.

Technically the read only custom fields are function calls and searching on functions in WHERE statements is not good and can lead to full table scans.

 

If you are using IEE client I instead recommend using an advanced search where you write the condition without any function calls.

If using IFS Cloud I suggest creating a customization if you really needs to search for it or some other way with lobbies etc.

Userlevel 5
Badge +7

Understood.

Thank you very much

 

Reply