very slow maintenance with external mariadb

[leoutation at gmx.fr]

Hi
Maintenance process is very slow when using mariadb external server.
Scanning or rescanning image files takes a long time. I checked mariadb
db with mariadb-check tool, it's ok.
This issue doesn't happen with sqlite.
There was no problem with Digikam version < 8.1 (may be 7.10)
Conditions:
Arch Linux system
mariadb 11.2.2
digikam git version
exiv2 0.28.1
Qt5 KF5 and/or Qt6 KF6

--
Maderios