aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJulius Härtl <jus@bitgrid.net>2023-11-30 16:30:21 +0100
committerJulius Härtl <jus@bitgrid.net>2023-11-30 20:51:48 +0100
commit0ccf84bb3174a0dba47938888d104db96dcacb1b (patch)
treea4f19dd82611725e9409d3dfeb47dcd4b9dcf824
parent3cd1d74a815531c9b7ae25ebbf8e7c45fa566e74 (diff)
downloadnextcloud-server-0ccf84bb3174a0dba47938888d104db96dcacb1b.tar.gz
nextcloud-server-0ccf84bb3174a0dba47938888d104db96dcacb1b.zip
perf: Add partial index on configvalue of preferences table
Signed-off-by: Julius Härtl <jus@bitgrid.net>
-rw-r--r--core/Application.php11
-rw-r--r--core/Migrations/Version13000Date20170718121200.php4
2 files changed, 15 insertions, 0 deletions
diff --git a/core/Application.php b/core/Application.php
index 2ad8b9f2a30..b033ea70871 100644
--- a/core/Application.php
+++ b/core/Application.php
@@ -44,6 +44,7 @@ use OC\Authentication\Listeners\UserDeletedWebAuthnCleanupListener;
use OC\Authentication\Notifications\Notifier as AuthenticationNotifier;
use OC\Core\Listener\BeforeTemplateRenderedListener;
use OC\Core\Notification\CoreNotifier;
+use OC\SystemConfig;
use OC\TagManager;
use OCP\AppFramework\App;
use OCP\AppFramework\Http\Events\BeforeLoginTemplateRenderedEvent;
@@ -81,6 +82,7 @@ class Application extends App {
$notificationManager->registerNotifierService(AuthenticationNotifier::class);
$eventDispatcher->addListener(AddMissingIndicesEvent::class, function (AddMissingIndicesEvent $event) {
+ $dbType = $this->getContainer()->get(SystemConfig::class)->getSystemValue('dbtype', 'sqlite');
$event->addMissingIndex(
'share',
'share_with_index',
@@ -237,6 +239,15 @@ class Application extends App {
['appid', 'configkey']
);
+ if ($dbType !== 'oci') {
+ $event->addMissingIndex(
+ 'preferences',
+ 'preferences_configvalue',
+ ['configvalue'],
+ ['lengths' => [80]]
+ );
+ }
+
$event->addMissingIndex(
'mounts',
'mounts_class_index',
diff --git a/core/Migrations/Version13000Date20170718121200.php b/core/Migrations/Version13000Date20170718121200.php
index da83b0732d8..b4968e06397 100644
--- a/core/Migrations/Version13000Date20170718121200.php
+++ b/core/Migrations/Version13000Date20170718121200.php
@@ -31,6 +31,7 @@
*/
namespace OC\Core\Migrations;
+use Doctrine\DBAL\Platforms\OraclePlatform;
use Doctrine\DBAL\Platforms\PostgreSQL94Platform;
use OCP\DB\ISchemaWrapper;
use OCP\DB\Types;
@@ -332,6 +333,9 @@ class Version13000Date20170718121200 extends SimpleMigrationStep {
]);
$table->setPrimaryKey(['userid', 'appid', 'configkey']);
$table->addIndex(['appid', 'configkey'], 'preferences_app_key');
+ if (!$this->connection->getDatabasePlatform() instanceof OraclePlatform) {
+ $table->addIndex(['configvalue'], 'preferences_configvalue', [], ['lengths' => [80]]);
+ }
}
if (!$schema->hasTable('properties')) {