By default, multilingual items are persisted in split tables. Monolingual items are persisted in one database table.
For items that are multilingual, the translations for the first 5 languages that you have added are persisted in the main table, while the translations for the rest of the languages are persisted in a separate table per language or language culture. This way, you avoid uncontrollable expansion of the main table that can, otherwise, reach the database limitation of maximum number of columns per table. The only exception is for the identifier of the type that is also a required field - for example, the Title. They are persisted in the main table for better performance.
In addition to the first 5 languages and cultures that are automatically added in the main table and are not persisted in split tables, you can persist more languages in the main table.
To do this, perform the following:
IMPORTANT: Do not delete any of the automatically added languages or cultures. These are the first 5 languages that you have added to the website.
RECOMMENDATION: For performance considerations, we do not recommend persisting more than 10 languages in the main table.
Sign up for our free beginner training. Boost your credentials through advanced courses and certification. Register for Sitefinity training and certification.
To submit feedback, please update your cookie settings and allow the usage of Functional cookies.
Your feedback about this content is important