Slow performance, working with large numbers of files

I have a library of about 40,000 images, mainly raw and some jpeg. Each shoot has its own folder, and each year's worth of shoots has its own parent folder. This makes browsing each folder very quick, whilst tidying older shoots away until needed. Most of my images are tagged with keywords, including subject and location.

Occasionally, I need to look at images with common keywords. This is where Bridge usually comes unstuck, especially if the number of results is in the thousands. I often dump the results of searches into a Collection, and then work with the Collection, adding and removing images as I go. More than a few thousand though and Bridge becomes deadful to use, with long delays after each action, even though I have a pretty fast and well-configured computer.

Looking in Task Manager, I see that these long pauses show Bridge working at 12% CPU. My guess is that Collection and Filter operations on the Content panel are using one core out of 8 on my i7 processor. This is frustrating when I'm waiting for up to a minute for Bridge to catch up. Layman's logic suggests that Bridge could do these things in up to an eighth of the time, if it used more of the CPU resources.

Does anyone know what I can do to speed things up? Any tips and tricks? Or is Bridge just not built for handling lots of images?

C: 256GB SSD, contains OS (WIn 10 Pro), apps (CC 2017) and Bridge cache

😧 512GB HDD, contains documents and OS TEMP folders

P: 1TB RAID 5, contains images and Ps scratch