diff options
| author | Christoph Wurst <christoph@winzerhof-wurst.at> | 2025-03-12 13:08:58 +0100 |
|---|---|---|
| committer | backportbot[bot] <backportbot[bot]@users.noreply.github.com> | 2025-04-24 11:34:07 +0000 |
| commit | 4017378c95791177da5ac1e53d1174ab094e90d2 (patch) | |
| tree | 7e1ec5424edad42570109f37c8fbc6708d61b044 | |
| parent | 6c8fa2a14543583c920790b5ccb86f00f4741dec (diff) | |
| download | nextcloud-server-backport/51438/stable31.tar.gz nextcloud-server-backport/51438/stable31.zip | |
perf(db): Extend index on cards_properties to cover name and valuebackport/51438/stable31
Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
| -rw-r--r-- | apps/dav/lib/Migration/Version1004Date20170924124212.php | 5 | ||||
| -rw-r--r-- | core/Application.php | 10 |
2 files changed, 9 insertions, 6 deletions
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; } diff --git a/core/Application.php b/core/Application.php index cfd0f90ef24..9a759da544c 100644 --- a/core/Application.php +++ b/core/Application.php @@ -147,12 +147,12 @@ class Application extends App { true ); - $event->addMissingIndex( + $event->replaceIndex( 'cards_properties', - 'cards_prop_abid', - ['addressbookid'], - [], - true + ['cards_prop_abid'], + 'cards_prop_abid_name_value', + ['addressbookid', 'name', 'value'], + false, ); $event->addMissingIndex( |