SQLite Event Manager File Category Cache - Performance Test Results
SQLite Event Manager File Category Cache - Performance Test Results
The Event Manager (EM) File Category store replication was updated to use SQLite, replacing LiteDB. Discovery of the possibility of the LiteDB cache files ability to become corrupted necessitated changes to be made. Thus, changes were made to improve reliability and stability of the file category store replication, by utilizing SQLite as the local cache. Enhancements were also made to the design with respect to synchronization of data to minimize event processing blockages and high memory usage due to the event queue backing up.
This document outlines the testing effort to capture any performance gain or losses with this transition.
These changes will be included in the upcoming 8.2 SP4 and 8.3 SP3 as well as upcoming major release 8.4.
