mrchntmarine wrote:
Not sure where to go with this.... Other than just use FAF app as suggested - but I wish Finder would work to search Comments section. I took 2 files and compared them. All of the files btw were scanned by the same process and the comments section were all cut and pasted. the 3 files that only show in Finder all show in Find Any File. I show 2 for comparison - 1 that does not show in Finder results and I that shows in both places. They seem identical besides the file name and subject matter and file size. I also do not know why now 3 files shoed up whereas before only one did. Baffled.
You're clearly trying to use Finder and Spotlight for professional-grade data. These are consumer devices. They're designed for consumer data. You can use it professional data, but you have to accept those limitations and be able to deal with them.
The most interesting part of your data are those 10 MB JPEG files. JPEG is a lossy, highly-compressed, poor quality image format. It's designed for throw-away images on web sites. It should NEVER be used for any kind of professional data.
But the most direct cause of the problem you're experiencing is most likely those 10 MB JPEG images. Spotlight is likely trying to open the entire image and look for text that can be read/translated/searched. Yes, yes, yes. I know what you're going to say next. You aren't asking for that. I know this. It doesn't matter. That's how it works. That's what I mean about consumer software. Most people wouldn't understand how to configure Spotlight like this, so Spotlight isn't configurable.
You can use a 3rd-party app that behaves differently. Or you can ensure that your data is suitable beforehand. Or you can just live with it. On my computer, I just did a search for JPEG files. The top hit was an 11 MB JPEG preview of a large satellite image. This "11 MB" image is 8k x 8k in size. While I can open it will Preview, if I tried to convert it to a different format to find out how big the image really is, it would likely blow out my VM. I did this just a few days ago and that's exactly what happened.
But if I wait, then my Spotlight results eventually fill up with many files larger than 11 MB. So clearly, Spotlight is choking on these large files. On my machine, it is able to handle those files. It's just slow. Your computer might have different Spotlight importers. It could be running more slowly or perhaps even crashing.
Look in System Settings > Login Items & Extensions and disable any 3rd party QuickLook and Spotlight extensions. You'll probably have to reindex (or just wait). That might fix it.