Re: "scan for new items" always scans the entire collection

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)

--=_2730c781c83e57005b6d2301f84d8cf2
Content-Type: multipart/mixed;
 boundary="=_83a6475df2630e7c01f860b04d4e3639"

--=_83a6475df2630e7c01f860b04d4e3639
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII;
 format=flowed

Hey there!

After upgrading Digikam to version 9.1, I have also noticed this weird 
behavior.

I have:

- EndeavourOS
- extra/digikam 9.1.0-4 (32.9 MiB 115.2 MiB) (Installed)
- MariaDB server as a backend

Config:

- "Scan for new items at startup" on
- "Fast Scan (...)" on

I have had this configuration for years (the Digikam DB may have worked 
and been upgraded for about 10 years). Up until upgrade - every time I 
have started Digikam, it scanned briefly (like seconds) for new items, 
if there were new items, it imported them (few seconds or minutes) and 
so.

But after upgrading, it scans and updates the entire collection every 
time. It takes more than 8hrs. Digikam rewrites all data stored in the 
database. It creates like 3GB of binlogs every time. If I log queries, 
it literally checks timestamp of a picture and than deletes and writes 
it's metadata (and thumbnails) all over again. After it finishes and I 
close it and start again, it happens again.

I have tried every DB maintenance option I have found in Digikam, still 
not working properly.

The only thing that did help - was to migrate the DB to SQLite (this is 
complicates things for me, as I synchronize images and metadata from 
Digikam to my webpage and SQLite cannot be as effectively backed up as 
MariaDB...).

It seems like Digikam may not be handling timestamps stored in MariaDB 
properly and decides that the metadata meed to be updated or something.

Robert
--=_83a6475df2630e7c01f860b04d4e3639
Content-Transfer-Encoding: 7bit
Content-Type: application/pgp-keys;
 name=0xDA8B0D6F.asc
Content-Disposition: attachment;
 filename=0xDA8B0D6F.asc;
 size=3805

-----BEGIN PGP PUBLIC KEY BLOCK-----

mQINBFIXLBMBEADKQk24K/hYqxYlHT7A3iZ9eIkE5kJuTQmY+PpQ93tZLjnr7vba
yrOpz4SiWvBtknwdkQeT3IC0uMhqUiggekYsH6HOU3IolkQIekNFCSGIDS9oqO3u
JjJouJGxk4ciCCDPPpq7zxptx6J+36sHdV5fsglt1wjN0sGEhBnT+miznDgp3DcY
Pr9yjwKDBvWmWf08x9GqoaKbJk3N955YtTHzakQ+Xgl6ZGBtdoHJF1s/yBF4C9Js
r0arqCdi891Iks4epUywKvHsXWEfzSUmEmikIg4ujRdO8lc+/EnKw8rmQ9u0Sc2S
kYTOz/G3pKjWhq1aWy7D+3PxjOpodFj1tpTjMWe+FpQmz+/Q/qhFSHveiZsgNnQ3
GngjYbucuHn9NEUEmPPPy2g4JI6hAjuHIhGzOYk0k3bOmWUGg59v4Gc5ezqjgDlE
oxOOrYwwNEY737zVL+3/JubBO4OxnqeEzDXIih5zSR5vYOv0ZpOuiV1RehTpD+eA
ccdv/7dMxDI9lJFaMm5kekQdXihvwnQyJCWLI9UVDxf5368C+dJlAV/uNlZFXpBT
I28aOMv2/roFvU0PqZivY1G8FDx/FeUo27ZDIESJXl4eCO+p0in6ZJGDlpupUOUY
287+Y6xbgNjMwjWG5/vDapr8kfFbwmQ89aHRke6JV4p4HvlSGyCjL3liOwARAQAB
tB9Sb2JlcnQgVmFsw61rIDxyb2JlcnRAdmFsaWsuc2s+iQI4BBMBAgAiBQJSFywT
AhsvBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIXgAAKCRBgh0Am2osNb44oD/9M8yxm
bYLiIB+nvVpIpSlf5YdNusTeeMLNvaYPAZ6hYEU0IbA0QvmmPBhfXySvqubrnTtV
lrp5f/jw95lsZquix7l0mbD7mzHliWeFBE68152Sy0Em9Pla+lvY8yCe5/LA/Oqo
yXd5g0ZXhPncNgFOAPkfk6hcXLxTsxtGilt9+RI7Q171fUjTGpACcpf89EKS6EE1
joC7CWSXbHr00E7a++mHnrowdDks1vDhJST2vDrgyk5yLYRC3F+3YKgcBj+RiWe0
Z5CPgHBAauAyXWLaq3R7vcbzmCd6mbfJqWGVm31f0pnF3KXXjbJNApUaJsuIzRmD
xfe9BAZOIBYiXC7WkK1ETmMvBke2iudjH//fWGVLuz4loELHQ116FgKKK4qPxVJB
8juTG/KD1G8TJCHkdzn6nhKtEKSHt8rdThzXEGO1AMkFzor9QEKDdrDkP2t/igw6
BQE8ec6/DP1/60MG8OONGLBa9xBu58kLUcxasUJ8OemvaCKO958uy8ldGar2ZglF
hpBUwxBgyrPEUsWc9yict4Y1i//yGDrd5bQD+eGtTNlLKHzIgCnQbbsmL2WXnaXY
wt7YKIlfITvGasesmoAUe0xsBJVzD+OWse7XMZvypSgYSRsDWBGFR+jKtEEnJ7jD
RDr8whZ0AKsJbOwxsRIvJ4ZP2NNoxbdUhzg6RbkCDQRSFywTARAA8FCXOuJDUo0+
VupauIdgTeEWGd/b8U4hyqJFt3nrKwY3bTg/SuZEMP5KNAUCdiTYhAjryJTNZrIg
rIh5VRStv88Zasz996ZrOuMuv9R/xGI3JHCrT7rgOp7wFmPUDsSD5kVg3q9BR3ko
7zszptox8cbkfVw8rSgfVBfgGLlvwsAh9Jxpcj4o8Gg6/JomHK4d2u1X+ZtO+zgz
5hMCoP4l+owu9GUzwuPXH0oMUAk+PZNW4jj3iJIMRMCC4c0K1iDB1wNXzqfujjBX
0V3f6FiKLgCCkOaD+KRIp7Mmyw9iqHI1SBdu4HmV0a2o7g2b4ZMl39dKehNHizuZ
IXHL/24Se1e/NCDTeZNQpD3KsiNXTtHxYzxfEnlQqsAR1g7eMbxb1jj2c83crdKl
yzaCjk6n9sg2Wc2IFn36uWWCBEtzxoU7UFJl3BSwQQ3ErYUwB8b6g5eNc/RbuCLG
bZp5D08QHnjZf9afvQe4xqiOt3tnYuYxB0Q3XvLhJhkxlkPMuRbD0VExlj67F2w4
llKBIzGDeFV/U/yKF4hav2mjEiEU4X/703u4rAsfo909sIOoiD42iGsEvzN3hBVF
S4cXGPuHdKgOvGen8v4ULPuBXAwb9FhPJLsnHPNchn5f/QkX94nOJd+gLMzGd4FT
CGltFrpR/wtdX5cgnrCEgUp36zcTlJ0AEQEAAYkEPgQYAQIACQUCUhcsEwIbLgIp
CRBgh0Am2osNb8FdIAQZAQIABgUCUhcsEwAKCRB0z4QIZ72F9+ueD/kBB7CM/Z0G
fxl1GpUNm2rBsrEBS+4FR60bONaKm8y5q0Fp+GDPcSk2dZvOycsm/eGqkFONNz27
6Fe3CeF0mqpVXj8eeczdM4+f65vRnLNd67owv7WxoHrE/bJJfBUJewv2GCmK5Bst
7xs02dGIzWgSqf9+1x3YtRgFbdieX47nyxPeQ7sZYonWASuql5jLI5J6p5EMIeii
7e94PkuXBJq+mgm4BvnMEwoCo5oICEaHw3FW+azk0/5Vm99Ov2MpJFIj4CCZcwpj
ROCP0A3uEHNMLa0m/3gj0u3Za3gmuHj9/8Jdd9FKSQQP1mOFqJof/87d08eTmTXg
mKX5LR68A3qVF9eE0KeSpvztYtgoFrAoRU7NJxj4ff1lJB3NPPCnRmvblO8T96kg
uBQ1QD1tn0iyotWnieGSiTD41R3V/pzqDPnw5INVScCIbATwT8d5RbQH+0Ikcm6X
bZ5/DUOd84/3zGRRC5i69IfO53DDLBppxNCkP/02+tNbxhI2TYs+X3uI9kXtJxSv
stGZSMcVDjcVN+WxdIb+BUWav8nbD5CAw3gSwBMURBl8OV8+U3ULdc7YbEYdVDZC
tLQ9Y57BeX4Qeia4+tZk5mZknNMu4JgP0w9euTMCBRTX/Lfqg7IFJpgPQIIHNyYw
d+wiQc12qB+AktyT+ZwckzjYVdRJHZbeI00oD/9Gz+IDjZhRjPB3MDZMwuH4uD7q
+7edw9KAYy0wUU32bC+cR7j7fz3I4I7WUqwYKvG3cWWVom0oHfXDQbmD2jzqWoR1
zOBv255JXz/iwfD6XrB1ocOvDX3FPxhDHE74Ti8SlaEa4Gpe/b3Bx8E/Q0HdQKTv
+Bfe4GlTWJGTsKRIbiZ/VbZ+TAcXZAqoYIeQjst+fDNw2C9iUEPaq7rilldiJsaz
M+ngW6A/S8eA2372TzMBOQY77rH0OIUJYtgykdnpQ8JCoi9NnpYT0pMulWyQkYME
g9LBiElfoLvsbBziv1QzeEkPCjVrc+F3hMK6XYejErW/CoyTLXx+s7YooZOJfFs7
jX3Z/f3zoORTCAbQPYccbgyk2+6BVkg9jx5OaBR5NzOQBjVNA+jkxZDuK5/d1dkJ
gx1ABYDuzvKFWmSQMWT3wHwzpZ6iYLx9jUjspRm5ahZ80GaFxJ/psvMqSMjIPfuu
uDn5v5PV26/HjcXcn32eQv7LN19IMRtyYcwp8BKfh6WCrIrh4Ofl9c3yiGY/21rG
hIRihHzNdTwLu6A+otFQD6an04je69XVURCecLu9iDLRZ3axZU/KfBV4sXblo2Gn
TH2OY6RNzlqyK0sysf7KaDFDpDw0/xlWGd9UKwho43wCoAF1lTbAlfcUcI1p9Xgt
QMp9rsurnE560FRoOQ==
=gBG1
-----END PGP PUBLIC KEY BLOCK-----

--=_83a6475df2630e7c01f860b04d4e3639--


--=_2730c781c83e57005b6d2301f84d8cf2
Content-Type: application/pgp-signature;
 name=signature.asc
Content-Disposition: attachment;
 filename=signature.asc;
 size=833
Content-Description: OpenPGP digital signature

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEUYEXWDL+Zkhre4mldM+ECGe9hfcFAmpPMrIACgkQdM+ECGe9
hfdyJxAAzFw/33z2h8b4wo0fXZUDgLYkUveTg8bbjUAC15Lxqd7M4MFxX2Dcp3u2
5a1tFTVkxn6SHLezeXeyiux2Sj7DUwBMzKWlcgpH7Fq4p0c67N0zazo/jnKb45VN
8HpBDobHESHA7CkROjHXDUNNjcUMg150RMerv4el9EF7V2fi8Hgh0mnAyEGM+uj3
6cZExrxpaHh9g9eNW/kC4MT2d6v2aAy9KRopQwOhJ8R5c0ufdlG1Hl5Jk52fJpEn
tmVlhnaN23EXrQi04d9OcHQLhqGggPvwDWyuRlFuH0k4knfFLGR8ZKc0VWUJdB8b
VIEIfORyy//gn8IktG9+9mWeMZKXbMLeKoWExghlhWF7cN+GivULbHnpJLg3k+0E
VU3jHfSEmjkdYr/fXtgs5ahMCDmxZUN3FxokYVXihvtjUzSXG4SaYS2NNdYH2jUD
0aYlvvRFp1NmmrFBu5SfZEhL56HBzkQTrMVYaAd0lsNR+hnIQFFWGHKjz6v3mlsK
NEx7VcjSqTAf5UalnsT+F2ZGMuXLUnI3pAj7o7P+JPlAOlBY7T5H98XOuKn7icl9
A9TKrwEw1orLCqT27unT01dgdDOSX0d9Z7ltk3+dr/Clmw0OcO3h61GtOJq+2m/Y
I8veFB3lj+uBFUy88JI0u+3uk8Yh+1jXbor7gsEQjvynptgSJC4=
=WHoU
-----END PGP SIGNATURE-----

--=_2730c781c83e57005b6d2301f84d8cf2--