Can one add a column only showing the (parent) folder containig the found item in the search list?

Discussion related to "Everything" 1.5 Alpha.
Post Reply
Biff
Posts: 1158
Joined: Mon May 25, 2015 7:09 am

Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by Biff »

Can one add a column only showing the (parent) folder containig the found item in the search list?
raccoon
Posts: 1017
Joined: Thu Oct 18, 2018 1:24 am

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by raccoon »

Yes, it's called the Parent column.
Biff
Posts: 1158
Joined: Mon May 25, 2015 7:09 am

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by Biff »

Ah, thank you. It is the "Parent Name", I assume, seems to show what I want.

After adding the column and trying to restart Everything Everything again obviously didn't save the database and did not close, I had to press "Terminate" in the window opening after trying to start Everything normally again and lost the last new indexes. Is there anything one could do to ALWAYS make Everything save the database / close correctly?
void
Developer
Posts: 16774
Joined: Fri Oct 16, 2009 11:31 pm

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by void »

Avoid clicking "Terminate" as this will kill the process that is saving your database to disk.

How large is your Everything.db?

Typically, the Everything.db should be around 100MB and only take a second to save to disk (per 1million files).

If the Terminate dialog is shown for more than 10 minutes, could you please send a mini crash dump:
Biff
Posts: 1158
Joined: Mon May 25, 2015 7:09 am

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by Biff »

Avoid clicking "Terminate" as this will kill the process that is saving your database to disk.
OK, yes, but what should I do instead? The process running with 30 % CPU and more would last as long as the computer is running and I couldn't start / use Everything for that time.

This is how big they are:

Image

How could I make Everything to make a backup of the database Every hour or every 6 hours?
void
Developer
Posts: 16774
Joined: Fri Oct 16, 2009 11:31 pm

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by void »

To auto save your database to disk every 6 hours:
  • In Everything 1.5, from the Tools menu, click Options.
  • Click the Advanced tab on the left.
  • To the right of Show settings containing, search for:
    auto save
  • Select db_auto_save_interval.
  • Set the value to: 21600000
    (interval in milliseconds = 6 hours = 6*60*60*1000 = 21600000)
  • Select db_auto_save_type.
  • Set the value to: Interval
  • Click OK.
db_auto_save_interval
db_auto_save_type
Biff
Posts: 1158
Joined: Mon May 25, 2015 7:09 am

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by Biff »

Many thanks!

I guess, it is not possible to somehow use easyer understandable values, e.g. minutes (instead of milliseconds).

Is there a way to let Everything save the database automatically (or do a back up) when a drive is plugged off (with the new index / updated index before from that external drive)?

Could Everything keep the last e.g. 5 backups before overwriting the oldest one?

This means, the db additionally (to the interval) is saved at 9 p.m. every day:
Image

And this means the db additionally (to the interval and the hour period, e.g. 9 p.m.) is saved at 10 p.m. or since Everything has been started every day:
Image
void
Developer
Posts: 16774
Joined: Fri Oct 16, 2009 11:31 pm

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by void »

I guess, it is not possible to somehow use easyer understandable values, e.g. minutes (instead of milliseconds).
No, sorry.
Everything uses milliseconds for advanced settings.


Is there a way to let Everything save the database automatically (or do a back up) when a drive is plugged off (with the new index / updated index before from that external drive)?
No.
Maybe with scripts, but that's beyond the scope of Everything.


Could Everything keep the last e.g. 5 backups before overwriting the oldest one?
No.
Everything will only keep one backup.


This means, the db additionally (to the interval) is saved at 9 p.m. every day:
No, Everything will only save at the specified hour when db_auto_save_type is set to daily.
The interval timer starts when Everything starts.
This cannot be changed.


And this means the db additionally (to the interval and the hour period, e.g. 9 p.m.) is saved at 10 p.m. or since Everything has been started every day:
No, Everything will only save at the specified hour and minutes when db_auto_save_type is set to daily.
db_auto_save_at_minute should range between 0-59.

Auto save settings
Biff
Posts: 1158
Joined: Mon May 25, 2015 7:09 am

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by Biff »

OK, thank you very much!
Typically, the Everything.db should be around 100MB and only take a second to save to disk.
So why then are my databases so big? Just because of the few properties in the main instance? Or / and because of the about 6.7 mio. items? 3,7 GB for these? Does that make such a big difference? Obviously.
void
Developer
Posts: 16774
Joined: Fri Oct 16, 2009 11:31 pm

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by void »

What are you indexing? -What is reported under Help -> Troubling shooting information.

Without property indexing, you should see about a 300MB database.
With property indexing you will see a larger database.
Biff
Posts: 1158
Joined: Mon May 25, 2015 7:09 am

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by Biff »

This is shown there:
Config: include_file_content=1
Config: content_include_only_files=*.doc;*.docx;*.pdf;*.txt;*.xls;*.xlsx;*.ods;*.odt;*.ott;*.scrivx;*.csv;*.ics;*.rtf;regex:^I:\\Dat\\txt\\[^.]*$
Config: content_exclude_recall_on_data_access=0
Config: properties=[
{"name":"Aspect Ratio","include_only_files":"*.mkv;*.mp4;*.avi;*.iso","fast_sort":1},
{"name":"Audio Bit Rate","include_only_files":"*.mkv;*.mp4;*.avi;*.iso","fast_sort":1},
{"name":"Audio Channels","include_only_files":"*.mkv;*.mp4;*.avi;*.iso","fast_sort":1},
{"name":"Audio Format","include_only_files":"*.mkv;*.mp4;*.avi;*.iso","fast_sort":1},
{"name":"Available Free Disk Size","include_folders":1,"include_files":0,"exclude_folders":"**\\**"},{"name":"Dimensions","include_only_files":"*.mkv;*.mp4;*.avi;*.iso","fast_sort":1},{"name":"Length","include_only_files":"*.mkv;*.mp4;*.avi;*.iso","fast_sort":1},
{"name":"Size on Disk","include_folders":1,"include_files":0,"exclude_folders":"**\\**","fast_sort":1},
{"name":"Total Bit Rate","include_only_files":"*.mkv;*.mp4;*.avi;*.iso","fast_sort":1},
{"name":"Total Disk Size","include_folders":1,"include_files":0,"exclude_folders":"**\\**","fast_sort":1},
{"name":"Used Disk Size","include_folders":1,"include_files":0,"exclude_folders":"**\\**","fast_sort":1},
{"name":"Video Bit Rate","include_only_files":"*.mkv;*.mp4;*.avi;*.iso","fast_sort":1},
{"name":"Video Format","include_only_files":"*.mkv;*.mp4;*.avi;*.iso","fast_sort":1}]
plugin: Everything Server.dll
Is there anything that could be done / indexed more efficiently?
Last edited by void on Sun Jun 11, 2023 10:46 am, edited 2 times in total.
Reason: trimmed log
void
Developer
Posts: 16774
Joined: Fri Oct 16, 2009 11:31 pm

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by void »

Your property indexes will use minimal resources.

It's most likely content indexing.

Please try disabling content indexing or reducing the number of files you content index under Tools -> Options -> Content.
Biff
Posts: 1158
Joined: Mon May 25, 2015 7:09 am

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by Biff »

OK, thank you.

So 233 MB and 466 MB for the other two instances (without countent indexing and less properties) is a common / normal size for such?
void
Developer
Posts: 16774
Joined: Fri Oct 16, 2009 11:31 pm

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by void »

For your ~6million files, yes.
Biff
Posts: 1158
Joined: Mon May 25, 2015 7:09 am

Re: Can one add a column only showing the (parent) folder containig the found item in the search list?

Post by Biff »

All right, everything OK so far. Thank you very much!
Post Reply