#55184Filling the entries from sys_registry does not use an index
Description
While filling the cache by Registry->loadEntriesByNamespace the Entries of the Database are fetched.
Count: 44 Time=0.00s (0s) Lock=0.00s (0s) Rows=111.7 (4915), webuser[webuser]@localhost
SELECT * FROM sys_registry WHERE entry_namespace = ‘S’
Since the is no index on entry_namespace this query is not cached and executed slower.
Solution: Add index on entry_namespace
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.