Page 1 of 1

Settings - catalog - maintenance button and dialog

Posted: Wed Feb 07, 2024 9:27 am
by user0
XnViewMP 1.6.4 64bit
Windows11 (23H2), display resolution 3840x2160, win scaling 150%


Settings - catalog


Suggestion A
settings_catalog_maintenance_button.png
settings_catalog_maintenance_button.png (3.43 KiB) Viewed 1605 times
  • rename button from Optimize to Maintenance
    as it opens Maintenance dialog

Suggestion B
settings_catalog_maintenance.png
  • regroup items in Maintenance dialog
  • rename OK to Run or Execute
  • clarify wording
    not sure if there have been any changes since:
    xnview wrote: Tue Jul 19, 2022 11:54 am 'Purge all thumbnails' remove thumbnails from database
    'Purge file data' remove file informations from database, in this case thumbnail will be invalid too
    but it looks like 'Purge file data' does not delete Images with Rating/Color<>0/Categories, not sure if it's desired behaviour.
    Guess wording needs to be improved, eg 'Purge files w/o Catalog metadata' or 'Purge all files' (and delete all files)

Suggestion C
  • execute VACUUM after 'Delete all' button routine
    Once all data is deleted from Xnview.db and Thumbs.db their size need to be reduced as well and its fast.

Re: Settings - catalog - maintenance button and dialog

Posted: Mon Feb 26, 2024 10:30 am
by xnview
See issue for current status and some details.

Re: Settings - catalog - maintenance button and dialog

Posted: Thu Mar 28, 2024 12:51 pm
by xnview
This problem is supposed to be fixed in XnView MP 1.7.0. Please check and confirm the bug fix here.

Re: Settings - catalog - maintenance button and dialog

Posted: Thu Mar 28, 2024 1:50 pm
by user0
170
A,B - done

C - why not perform VACUUM after Delete All action?

Re: Settings - catalog - maintenance button and dialog

Posted: Mon Apr 01, 2024 1:05 pm
by xnview
user0 wrote: Thu Mar 28, 2024 1:50 pm C - why not perform VACUUM after Delete All action?
A VACUUM is made after the transation

Re: Settings - catalog - maintenance button and dialog

Posted: Mon Apr 01, 2024 2:54 pm
by user0
hm, Thumbs.db remains the same size (eg 5Mb) after "Delete all" for me
size is reduced (to 40 KB) only if one of the following actions is performed after "Delete All":
- Optimize database OR
- manual executing VACUUM, eg via "DB Browser for SQLite"

Re: Settings - catalog - maintenance button and dialog

Posted: Tue Apr 02, 2024 8:37 am
by xnview
user0 wrote: Mon Apr 01, 2024 2:54 pm hm, Thumbs.db remains the same size (eg 5Mb) after "Delete all" for me
size is reduced (to 40 KB) only if one of the following actions is performed after "Delete All":
- Optimize database OR
- manual executing VACUUM, eg via "DB Browser for SQLite"
I don't know why but sqlite doesn't want to execute VACUUM on thumb.db only on xnview.db