Fixes #7195 Make code more efficient by only updating the numeric archive tables (blob tables don't have `done` flags)

1 files changed, 6 insertions, 1 deletions

diff --git a/core/DataAccess/ArchiveInvalidator.php b/core/DataAccess/ArchiveInvalidator.php
index 8ff0516f11..916d94991b 100644
--- a/core/DataAccess/ArchiveInvalidator.php
+++ b/core/DataAccess/ArchiveInvalidator.php
@@ -174,7 +174,12 @@ class ArchiveInvalidator {
 
         // In each table, invalidate day/week/month/year containing this date
         $archiveTables = ArchiveTableCreator::getTablesArchivesInstalled();
-        foreach ($archiveTables as $table) {
+
+        $archiveNumericTables = array_filter($archiveTables, function($name) {
+            return ArchiveTableCreator::getTypeFromTableName($name) == ArchiveTableCreator::NUMERIC_TABLE;
+        });
+
+        foreach ($archiveNumericTables as $table) {
             // Extract Y_m from table name
             $suffix = ArchiveTableCreator::getDateFromTableName($table);
             if (!isset($datesByMonth[$suffix])) {