2062 - Manage Database

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: 2062 - Manage Database

Re: 2062 - Manage Database

by Ludek » Mon Mar 13, 2017 4:16 pm

The "Optimize database (complete)" actually just copied tables and its data.

The "Rebuild Database" can re-create removed triggers and indexes and also re-creates relation tables like artists, albums, genres, folders (build 2063+) from the Songs table.
So "Rebuild Database" is more powerful to repair a corrupted/partial or a malformed database.

Re: 2062 - Manage Database

by dtsig » Sun Mar 12, 2017 9:53 pm

Thanks for the quick reply

Re: 2062 - Manage Database

by Peke » Sun Mar 12, 2017 9:16 pm

Hi,
FULL was removed due the REBUILD option regarding that Rebuild is faster than FULL.
BACKUP make copy of your MM.DB just to be safe
REBUILD replaces FULL as it recreated whole MM.DB Table structure and not just Indexes and triggers that were in FULL Version.

2062 - Manage Database

by dtsig » Sun Mar 12, 2017 8:43 pm

there does not appear to be a "FULL" optimize available. Or am i just misreading?
What does the backup really do .. it takes more time to click the ok button that it takes to complete .. which seems a little fast.
What does Rebuild Database do?

Top