I think my issue is a lot of them slow down to a crawl and Digikam fell under this problem for me. Importing thousands of images and videos isnt easy. I did like that Photoprism had a WebUI made it easy to access the photos across my network.
Yep, the only photo library tool I’ve used that can handle 40K raws is Lightroom and Photomechanic. Everything else can’t handle ~2TB of photos.
I am genuinely curious of what a good solution would be to this problem, because I love Photos on Mac but its not perfect either, one key thing Photos does insanely well is face grouping.
I use Digikam on a 3 TiB collection and it works great.
What database are you using and did you slowly build it up or what?
The Digikam DB is SQLite on a fast NVMe drive. The photos are on a 4 TB SSD. I have been using Digikam for maybe a decads, so the collection has been growing with me, but no issues so far.