View Issue Details

IDProjectCategoryView StatusLast Update
0007898MMW v4DB/FileMonitorpublic2011-06-13 13:37
ReporterLudek Assigned To 
PriorityurgentSeveritycrashReproducibilityalways
Status closedResolutionfixed 
Product Version4.0 
Target Version4.0Fixed in Version4.0 
Summary0007898: Trying to clear database freezes MM
DescriptionTested with build 1380:
1. Go to 'File' -> 'Clear database...'
2. confirm by typing 'YES'
=> freeze
Additional Informationhttp://www.mediamonkey.com/forum/viewtopic.php?f=6&t=58156
TagsNo tags attached.
Fixed in build1382

Activities

Ludek

2011-05-30 13:12

developer   ~0025762

I debugged the issue and it seems that SQL query 'DELETE FROM Songs' takes too long.

Jiri, wouldn't it be better and safer to force the users to restart MM and start with newly created DB?

jiri

2011-05-30 17:29

administrator   ~0025767

We can't just replace the DB, because some data persist even in the new DB (e.g. Devices table). We could copy such data to the new DB, I'm sure whether it's worth the effort though.

I wonder, is there any diff since MM 3? I don't think that there can be any significant slowdown, since there weren't any really big DB schema changes?

Ludek

2011-05-31 08:49

developer   ~0025788

Last edited: 2011-05-31 08:52

In MM3 it was several times faster because of DB triggers that were enhanced in MM4.

Nevertheless I optimized the whole procedure of clearing DB so that the tables without triggers are cleared at first. This way the whole process takes 15 seconds on my DB while it took 2 minutes with build 1381. It is even faster than with MM3.

Fixed in build 1382.

peke

2011-06-13 13:37

developer   ~0026082

Verified 1388