Following some recent performance and unavailability challenges that we experienced with our learning environment, SAP is advising us to work on an Archiving Solution (understand, copy/move the data somewhere else, then delete it)
The items being made inactive is apparently not enough and even inactive item labels are impacting reports and admin operations ...
Have you ever heard a similar request from SAP (or decided to go after archiving by yourselves) ?
If so, I would be intrested to hear about your experience and the solution developed.
As a global business, we have enabled 24 languages in the LMS
Therefore, all of our items and curricula are translated in 24 languages (title & descriptions).
Even when there is no local translation, we have as business rule to copy the english text in the local language.
This is because people don't always think about having english as the secondary search language.
When an item becomes inactive the translations remains in.
SAP is telling us that this is causing inefficiencies in any query being executed when admin run reports or other activities, ultimately leading to a lot of period where the system is simply not available.
They say the large volume of labels, especially for inactive items, needs to be "archived".
That is interesting that the labels are causing performance issues. What is the volume of Items and Curricula in your system?
I would expect that SAP would optimize their DB and queries to account for this. There are many global organizations using extensive label translations.
I would be interested to hear if any other organizations are experiencing performance issues due to multi-language labels. Is anyone else experiencing issues?