From 55b6a89c7c42d2bde3da3c849c8ba0c124b40867 Mon Sep 17 00:00:00 2001 From: Michael Date: Sun, 24 Jul 2022 13:49:57 +0000 Subject: [PATCH] Optimizing --- src/Protocol/ActivityPub/Queue.php | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/src/Protocol/ActivityPub/Queue.php b/src/Protocol/ActivityPub/Queue.php index 7b91609bdb..011101eed7 100644 --- a/src/Protocol/ActivityPub/Queue.php +++ b/src/Protocol/ActivityPub/Queue.php @@ -24,6 +24,7 @@ namespace Friendica\Protocol\ActivityPub; use Friendica\Core\Logger; use Friendica\Database\Database; use Friendica\Database\DBA; +use Friendica\DI; use Friendica\Util\DateTimeFormat; /** @@ -224,6 +225,13 @@ class Queue // We delete all entries that aren't associated with a worker entry after seven days. // The other entries are deleted when the worker deferred for too long. DBA::delete('inbox-entry', ["`wid` IS NULL AND `received` < ?", DateTimeFormat::utc('now - 7 days')]); + + // Optimizing this table only last seconds + if (DI::config()->get('system', 'optimize_tables')) { + Logger::info('Optimize start'); + DBA::e("OPTIMIZE TABLE `inbox-entry`"); + Logger::info('Optimize end'); + } } /** -- 2.39.5