Very large query performance

General discussion related to "Everything".
Post Reply
aviasd
Posts: 28
Joined: Sat Oct 07, 2017 2:18 am

Very large query performance

Post by aviasd » Mon Apr 27, 2020 12:44 pm

Hi

I'm trying to use everything as a favorites menu to access favorite folders.
Currently I'm doing wfn:<Folder1|Folder2|Folder3|...Folder70> which takes about 4 seconds for everything to return the result list.
Is there a way I could speed this up using different query?

Thanks

Edit: About 50% of the favorites are using environment variables as part of the name. Not sure if it could affect performance

NotNull
Posts: 2030
Joined: Wed May 24, 2017 9:22 pm

Re: Very large query performance

Post by NotNull » Mon Apr 27, 2020 1:32 pm

Take a look at the filelist: function, like:

Code: Select all

filelist:"C:\Program Files\7-zip|%ProgramFiles%\common files"
This is built to match many-to-many and might be faster (please test and report; that is useful information for all of us)


The easiest way to create this search query (that I can think of):
  • Create a textfile with all your favourite folders, one per line.
    Don't end with an empty line (ie: don't press ENTER after your last folder)
  • Go to Menu:Serach > Advanced Search
  • Scroll down to Search for a list of file names:
  • Click the browse button to add (the contents of) your textfile
  • Click OK
  • Save as bookmark
  • Done
Last edited by therube on Tue Apr 28, 2020 6:37 pm, edited 1 time in total.
Reason: s/wit/with/

aviasd
Posts: 28
Joined: Sat Oct 07, 2017 2:18 am

Re: Very large query performance

Post by aviasd » Mon Apr 27, 2020 1:46 pm

Very Cool :)

I keep forgetting about the filelist option...

Yes, this method (filelist:... ) is working perfectly and is preferable than opening an .efu because it retains all the folder icons!

Thanks !

NotNull
Posts: 2030
Joined: Wed May 24, 2017 9:22 pm

Re: Very large query performance

Post by NotNull » Mon Apr 27, 2020 1:50 pm

You're welcome!
(what about performance? How long does it take?)

aviasd
Posts: 28
Joined: Sat Oct 07, 2017 2:18 am

Re: Very large query performance

Post by aviasd » Mon Apr 27, 2020 1:53 pm

Instantaneous :)
Probably less than 50ms but I cannot measure. xactly

NotNull
Posts: 2030
Joined: Wed May 24, 2017 9:22 pm

Re: Very large query performance

Post by NotNull » Mon Apr 27, 2020 2:03 pm

Wow, that *is* fast!
(and accurate enough for me )

Thanks for posting!

Post Reply