From 017370e27cbd5123c8eed49a7626475c2de69357 Mon Sep 17 00:00:00 2001 From: Christoph Wurst Date: Tue, 14 May 2024 12:12:29 +0200 Subject: [PATCH] perf(systemtags): Add index for systemtags_object_mappings.objectid Signed-off-by: Christoph Wurst --- core/Application.php | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/core/Application.php b/core/Application.php index c25fb4fb6f4..ffe4f60549c 100644 --- a/core/Application.php +++ b/core/Application.php @@ -244,6 +244,12 @@ class Application extends App { 'systag_by_tagid', ['systemtagid', 'objecttype'] ); + + $event->addMissingIndex( + 'systemtag_object_mapping', + 'systag_by_objectid', + ['objectid'] + ); }); $eventDispatcher->addListener(AddMissingPrimaryKeyEvent::class, function (AddMissingPrimaryKeyEvent $event) { -- 2.39.5