The speed of the disk where the proxies are being stored is generally the primary factor in how long it takes to do the process. You can send us your log file if you think there was an issue with it that you'd like us to look into.
The first preview generation, running at about 6 batches/second, was on the same drive & connected to the same port as the second preview generation running at about 1 batch/second. The other conditions were also much the same so this seems unlikely to have been related to the drive itself. Disk First Aid gives the drive a clean bill of health.
The reason that I was running this 'scan to catalog' of about 180,000 Nikon .NEF files (from an external drive) is that I was finding sort operations involving .NEF files on an internal 6TB WD drive were running slowly or (mostly) failing to complete. I wanted to eliminate the drive as the cause so took a backup of that drive and scanned it into a different (test) catalog. That’s when the preview generation speed anomaly appeared but that now seems to be just one aspect of a wider problem.
Once the backup .NEFs had been scanned into the test catalog I repeated some of the sort operations that had failed & they failed in the same way with this new setup (different catalog, different drive). The problem only occurs with .NEF files & with the numbered sort items shown in the dropdown. Filename, mod date and the others in the top part of the menu are fine. I assume that the data for those is readily accessible but that the other sort modes need to read the data from file. The .NEF data is a sidecar .xmp but all the other image formats have the data embedded so perhaps it’s reading the .xmp files that is problematic. My .DNG files have embedded metadata & they, like .TIF, .JPG, .PSD etc all sort quickly.
I tried to attach a couple of recent logs but I get an error that your upload folder is full! I'll try again later.
Let me know if there are any specific tests that might help clarify this problem.
David