Recently, my DB "lost" everything (though browing it with DB Browser for SQLLite showed evertyhing was there) so I had to to a full rescan of my files (over 300k files of network connection) first by refreshing the collection item in settings and then, when I realised old files were stil in the database, then with Tools / Maintenance. It goes quite smoothly as long as I'm using the PC but, for instance, if I leave for the night, the PC will go to sleep (if sleep timeout is active) and the job will stretch forever.

Generally, not preventing to go to sleep for background tasks _may_ be a good thing but it feels to me like it's clear it is not the case for this multi hours/days process.

The option could be in the background task panel when we explode it, maybe? Something like "Prevent sleeping until all tasks are complete"?