Configuration Guidelines > Performance Guidelines >

Multilingual LOVs Query and Cache Performance

Multilingual List of Values fields are implemented below the business component level. Fields that point to MLOVs with enabled target columns return display values that match the client language setting.

For display, the underlying language-independent code is converted to its corresponding display value using a Siebel eBusiness Applications lookup. For searching and sorting, however, a database join is performed by your Siebel application to the list of values table. Therefore, when configuring the application, make sure that any configuration directly involving the list of values table is compatible with your Siebel application MLOV functionality.

When a view with MLOVs is displayed for the first time, a separate query on the S_LST_OF_VAL table is made for each field that has an MLOV. The query obtains all of the display values for that MLOV and writes the values to the in-memory cache. When the view is subsequently displayed during the same session, the values are obtained from the cache rather than issuing another query.

For more information on configuring MLOVs, see Siebel Tools Reference.


 Configuration Guidelines 
 Published: 18 April 2003