Settings - catalog - maintenance button and dialog

[user0]

XnViewMP 1.6.4 64bit
Windows11 (23H2), display resolution 3840x2160, win scaling 150%

Settings - catalog


Suggestion A

settings_catalog_maintenance_button.png (3.43 KiB) Viewed 1604 times

• rename button from Optimize to Maintenance
  as it opens Maintenance dialog

Suggestion B

• regroup items in Maintenance dialog

• rename OK to Run or Execute

• clarify wording
  not sure if there have been any changes since:

  '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.

[xnview]

See issue for current status and some details.

[xnview]

This problem is supposed to be fixed in XnView MP 1.7.0. Please check and confirm the bug fix here.

[user0]

170
A,B - done

C - why not perform VACUUM after Delete All action?

[xnview]

C - why not perform VACUUM after Delete All action?

A VACUUM is made after the transation

[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"

[xnview]

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