View Issue Details

IDProjectCategoryView StatusLast Update
0021860MMW 5DB / Backuppublic2026-01-15 16:58
ReporterLudek Assigned To 
PriorityurgentSeverityfeatureReproducibilityhave not tried
Status feedbackResolutionopen 
Product Version2024.2 
Target Version2026 
Summary0021860: Optimize database before backup
DescriptionRusty has sent me his DB that had 2.5 GB size just for 24K of tracks..
After doing 'Optimize database' the size reduced to just 250 MB !!

So it would make sense to optimize DB before doing a backup (to reduce also the size of the backups)

The question just is how often perform the optimization..
To be speeced..
TagsNo tags attached.
Fixed in build

Relationships

related to 0021652 resolvedLudek Rebuild database should disable other options when selected 

Activities

Ludek

2026-01-15 15:34

developer   ~0080312

Last edited: 2026-01-15 15:50

FYI: there is already a new UI for v2026 (per 0021652 ) , so I would rather solve it with target 2026 so that it can be tested through beta testing circle
image.png (38,756 bytes)   
image.png (38,756 bytes)   

Ludek

2026-01-15 15:39

developer   ~0080313

Last edited: 2026-01-15 15:49

Because 'Optimize database' is quite fast task (usually takes less time than the actual backup where compressing part takes the most)
then I would still prefer to Optimize before backup, so probably just a new checkbox

[x] Optimize database before backup

.. BUT this could imply that just the DB that is backed up is optimized

So cleaner approach would be to separate it from backup (like suggested by Rusty) and add the scheduled maintenance, but in that case I believe that 'Optimize database' is the only task that should be scheduled for maintenance.
Idealy if MM could self-detect that DB needs to be optimized and suggested to the user the optimization.

The detection could be based on total amount of tracks in DB versus overal DB size.

Maybe if DB size is over 2GB and the total amount of tracks is less than 100K as a treshold for optimization?