View Issue Details

IDProjectCategoryView StatusLast Update
0020113MMW 5DB / Backuppublic2023-10-03 12:51
ReporterLudek Assigned To 
PriorityimmediateSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version5.1 
Target Version5.1Fixed in Version5.1 
Summary0020113: Scanning is much slower in 5.1 (regression)
DescriptionTested with LowLander's database created prior to 5.1 (300 K tracks)
1) Scanned folder with 102 files in 7 seconds
2) Updated to 5.1.0.2806, waiting for DB upgrade to finish
3) Deleted the 102 files from the database
4) Scanned the same 102 files using 5.1.0.2806
=> it now took 49 seconds!!

i.e. scanning in 5.0.4 is 7 times faster!
Additional Information[Ticket # 5934]
TagsNo tags attached.
Fixed in build2810

Relationships

related to 0019830 closedmichal List (by Album) view can remove custom description of album 
related to 0016714 assignedmichal Grid (by Album) Sorting is Limited 

Activities

Ludek

2023-06-22 14:05

developer   ~0072310

The culprit is this DB trigger added by Michal in course of fixing 0019830 and 0016714
image.png (64,447 bytes)   
image.png (64,447 bytes)   

Ludek

2023-06-22 14:06

developer   ~0072311

Last edited: 2023-06-22 14:16

Particularly this part of the DB trigger:

 ' UPDATE Albums SET Rating = (SELECT COALESCE(ROUND(AVG(Rating)), -1) FROM Songs WHERE (Songs.Rating>=0) AND Albums.ID=new.IDAlbum);

michal

2023-06-22 19:25

developer   ~0072321

Last edited: 2023-06-22 19:26

Problem is, that we need to fill this info too, because of 0016714.
Fix will be harder to do, as I will need to fill the info different way later and handle all possible situations including premature end of app run.

michal

2023-06-30 11:41

developer   ~0072375

Fixed in build 2810.

peke

2023-10-03 12:51

developer   ~0072972

Verified 2817

Based on several concurrent restart of scans MM 5.1 is aprox 10-15% slower than MM4, which is reasonable due the number of improvements.

Further optimization shoul dbe added as new bugs in case of need.