Managing user field inline storage

User fields can be stored in two different ways, either "inline" in businessClass_user_fields (which is a defined buffer field on the business class record) or in the UserField_Storage business class. If a business class has many user fields defined and those fields are used for filtering, the filtering performance is negatively impacted. In this case, Infor recommends that the fields be moved out of inline storage. If filtering is not used on the user fields, then inline storage can improve the performance of creates.

There are multiple ways to manage which storage type is used:

1. Use the DisableInlineUserField configuration parameter in the framework component to set the storage option for an application data area. The valid values are True, False, OnUpdate. If the value is OnUpdate, the user field will be stored inline on the create but will be moved out of inline storage on an update.
2. Use the DisableInlineUserField.BusinessClass configuration parameter in the framework component to set the storage option for the user fields in the specified business class. The valid values are True, False, OnUpdate. If the value is OnUpdate, the user field will be stored inline on the create but will be moved out of inline storage on an update.
3. In the LPL for the business class form where the persistent user field is defined, add the following to the field definition:

   disable inline storage [for updates]

4. In the Configuration Console, run the Update Inline Storage action for an individual user field.