View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0021860 | MMW 5 | DB / Backup | public | 2025-11-07 11:53 | 2026-01-15 16:58 |
| Reporter | Ludek | Assigned To | |||
| Priority | urgent | Severity | feature | Reproducibility | have not tried |
| Status | feedback | Resolution | open | ||
| Product Version | 2024.2 | ||||
| Target Version | 2026 | ||||
| Summary | 0021860: Optimize database before backup | ||||
| Description | Rusty 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.. | ||||
| Tags | No tags attached. | ||||
| Fixed in build | |||||
|
|
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 |
|
|
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? |