User field inline storage management

You can store user fields 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. We recommend 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.

These are your options to manage which storage type is used:

  • 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 is stored inline on the create but moved out of inline storage on an update.
  • 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 is stored inline on the create but moved out of inline storage on an update.
  • In the LPL for the business class form where the persistent user field is defined, add these to the field definition:
    disable inline storage [for updates]
  • In the Configuration Console, run the Update Inline Storage action for an individual user field.
Note: The Update Inline Storage action also run automatically in these conditions:
  • When a DisableInlineUserField configuration parameter is created, updated, or deleted.
  • When the user field is changed to add or remove disable inline storage for updates.
  • When a value of a user field is set on a create and the user field or business class configuration parameter is set to update only.