Issue Bug Closed

#55184Filling the entries from sys_registry does not use an index

Ingo Schmitt 01/20/14, 19:02 updated 03/11/14, 18:03

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.