I frequently find myself looking for files on my computer. 99.9% of the time I am looking for a file by name rather than by contents. Typically there are two ways to find a file when you don't know what folder it is in. You can do it from the command line as in
D:\
dir *partname* /s
This generally takes quite a while with the larger drives/partitions in use these days. You can also go to an Explorer window and type something in the search box. I find this horribly slow as well. For my purposes, I want a fast way to get the full name and location of a file and the following free software was recommended to me by a trusted expert. It consunmes pretty close to zero resources. Once it has built a database of files (which files and folders are configurable), searching is almost instantaneous. Searching has many options. If you know a file name contains certain words you can just type them into the search box separated by spaces and a list (updated as you type) of file names containing all of the entered strings (in any order) is displayed. You can also separate terms by a vertical bar to use an OR instead of AND search. There are more complex searches such as
dm:today
dm:thisweek
to display files with the corresponding date modified (use dc for date created). There are many other search parameters for more complex searches (regex patterns are also available for the hardcore).
Once you have a list of files (file names in one column, paths in another, etc) you can run/open the file from the list in the same way you would from an Explorer window.