Rebuild the Database Index
System administrators can manually start the process to rebuild the database index to optimize the performance of searches in the LMS. The database index is automatically rebuilt once per week as part of the Standard Weekly Tasks scheduled task. While the index is being rebuilt, users may notice a performance impact when searching the LMS. The larger the database, the longer it takes to rebuild the index.
In addition to the automatic weekly rebuild, the database index is rebuilt as part of the start up process. A System Configuration settings controls which parts of the database index are rebuilt during or after startup. This is configured in the ekp.properties file for the index types (Competencies, Job Profiles, Reference Resources, Learning Modules, Users, News, Module Sessions and Transcripts). Index types not rebuilt during startup will be rebuilt in the background after the site has been restarted; while this is taking place there will be data not visible via the interface.
To rebuild the index
- Go to . The Rebuild Index page opens and shows the number of records in the database that are missing from the index.
- Click Rebuild.
