I was troubleshooting long-running backup times on my Synology NAS. Even though no files change much of the time, a backup job takes over an hour.
I checked the Live log and see that a UsageReport SQL function is taking 45+ minutes:
Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE “UsageReport-F182E685FB5B234C9114735E1859EC9E” AS SELECT “VolumeID” AS “VolumeID”, SUM(“ActiveSize”) AS …
From searching the posts here, this seems to be Duplicati looking for compactable volumes. Is that correct?
The NAS doesn’t have the most powerful CPU, and Duplicati is protecting 650GB of data (at 50MB volumes). Maybe 45+ minutes for this process is expected?
Could this function be multithreaded in the future? I see it maxes out one of the four cores in the NAS CPU. Or maybe Duplicati could be enhanced to only do compaction check once a week? (Just throwing out ideas…)