I am using Scrivener for “all my texts”, it is great and the search function perfect.
In my seach for background material it is invaluable… and I did not foresee that my curiocity would span so man subjects… so… my combined project had become bloated (closing in on 100GB). Scrivener can handle this and so can my Mac Studio, but if there is a hickup, Scrivener will need to rebuild index… and this in my case may take hours, and put heavy use on the resources.
So, inspired by input from a Mac/tech blog (Daring Fireball) I am now using a small and elegant app (FAF, Find Any File) whenever I have the urge to locate any documents where, say “pooltable” occours.
FAF will look into disk , folder or documet, all the while I continue my work.
So I have dropped my HUGE 6-years combined Project, and rely on the individual yearly versions. Whenever I now get curios I simply direct FAF to the folder where the projects reside. It works fine for me this way and it put less strain on the Mac Studio.
“As a side effect” FAF will work on any info you have on you mac besides Scrivener projects!
It found me an e-mail from 10 years ago I completely forgot about, but it contained “pooltable” 
GreyT