Switch Off Language-Specific Sorting to Improve Performance

SADL runtime uses language-specific alphabetical sorting as the default sort strategy. If sort criteria are defined, the records in the result are sorted according to the alphabet of current user's language.

Prerequisites

This feature is available since SAP NetWeaver 7.40 SP08.

Context

The disadvantage of using language-specific sorting is that the database might need much more time to execute the query, even with factor 10 or more. To protect performance, you can switch the language-specific sorting off, if it is not needed. It is recommended that you use language-specific sorting only if:

  • $orderby is defined on a text field or
  • $filter with operators 'gt', 'ge', 'lt' or 'le' is defined on a text field.

The text field is a database field that contains language-specific texts. In all other cases you can switch the language-specific sorting off by calling the following method:

io_query_options->set_locale_disabled( abap_true ).