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:33:44 +0000 |
| commit | 84e933fab556ba99e906f718d9f726bee5838f24 (patch) | |
| tree | 0806b093d9a22eb2d1d0e9088c2cb2e635bb56ea | |
| parent | ea47b4d1b9ffcea1f7704a07b494b14cdb14c77f (diff) | |
| download | nextcloud-server-backport/51438/stable29.tar.gz nextcloud-server-backport/51438/stable29.zip | |
perf(db): Extend index on cards_properties to cover name and valuebackport/51438/stable29
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 4cc795e1aec..34ff5d3ebc0 100644 --- a/apps/dav/lib/Migration/Version1004Date20170924124212.php +++ b/apps/dav/lib/Migration/Version1004Date20170924124212.php @@ -46,7 +46,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 ffe4f60549c..2af80eca7bb 100644 --- a/core/Application.php +++ b/core/Application.php @@ -171,12 +171,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( |