From 8388646ae77a5ae7b53e5ce20958f156c32f87c4 Mon Sep 17 00:00:00 2001 From: Christoph Wurst Date: Wed, 12 Mar 2025 13:08:58 +0100 Subject: perf(db): Extend index on cards_properties to cover name and value Signed-off-by: Christoph Wurst --- apps/dav/lib/Migration/Version1004Date20170924124212.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'apps') diff --git a/apps/dav/lib/Migration/Version1004Date20170924124212.php b/apps/dav/lib/Migration/Version1004Date20170924124212.php index a8b85469214..fbfec7e8e2d 100644 --- a/apps/dav/lib/Migration/Version1004Date20170924124212.php +++ b/apps/dav/lib/Migration/Version1004Date20170924124212.php @@ -28,7 +28,10 @@ class Version1004Date20170924124212 extends SimpleMigrationStep { $table->addIndex(['addressbookid', 'uri'], 'cards_abiduri'); $table = $schema->getTable('cards_properties'); - $table->addIndex(['addressbookid'], 'cards_prop_abid'); + // Removed later on + // $table->addIndex(['addressbookid'], 'cards_prop_abid'); + // Added later on + $table->addIndex(['addressbookid', 'name', 'value'], 'cards_prop_abid_name_value', ); return $schema; } -- cgit v1.2.3