Loading query log takes several seconds since core 6.3

Help
14

6 seconds loading time at minimum. No matter if accessed via http oder https.

sudo service pihole-FTL stop
sudo cp /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL_BU.db
sudo sqlite3 /etc/pihole/pihole-FTL_BU.db "PRAGMA integrity_check;"
-> ok
sudo service pihole-FTL start
sudo pihole status
[✓] FTL is listening on port 53
  [✓] UDP (IPv4)
  [✓] TCP (IPv4)
  [✓] UDP (IPv6)
  [✓] TCP (IPv6)

[✓] Pi-hole blocking is enabled

Ah I see pihole -d is also performing an integrity check so this was not necessary in addition.

*** [ DIAGNOSING ]: Pi-hole FTL Query Database
-rw-r----- 1 pihole pihole 3,7G 14. Dez 18:53 /etc/pihole/pihole-FTL.db
[i] Checking integrity of /etc/pihole/pihole-FTL.db ... (this can take several minutes)
\ 01:03

So here’s the redacted pihole debug:

First upload (potentially failed- /usr/local/bin/pihole: Zeile 38: /etc/pihole/versions: Keine Berechtigung - as pihole almost everywhere needs a sudo since v6): https://tricorder.pi-hole.net/fCJVoQFK/ .

Second upload without any errors:
Upload successful, your token is: https://tricorder.pi-hole.net/t7MzLlg0/