Page 1 of 1

[SOLVED] MM Properties opens slowly

Posted: Sat Jan 26, 2019 2:53 pm
by STINO
Dear All,
Since I exceeded ~ 100.000 files in the mm archive, the properties operations became slow. Now, with > 150.000 files, the working with properties is not really possible any longer. :oops:
The archive is in drive C:, the music files are on an external 2 TB USB 3 HD. The music is organized in directories
A\abba\record1\titles ... Z\zztop\record1\titles.
There are only a few playlists.
Files in my music 185.000
directories: 15.000
size: 1,06 TB
MM.DB: 382.666 KB (fresh reorganized)

Could please advise whats to do?
All other functions like searching ... are working fine.

Many thanks in advance and
best regards
Stefan

Re: MM slow

Posted: Sat Jan 26, 2019 3:04 pm
by Lowlander
Are you working through My Computer or a Library node (like Music) in the Media Tree? Are you saying you've recently run complete optimization (File > Maintain Library)?

Re: MM slow

Posted: Thu Jun 20, 2019 6:29 am
by STINO
dear lowlander,

i am using the directory structure offered in mm. e.g.

music\location\hd\musik\a\abba\waterloo\watchout.mp3
...
music\location\hd\musik\z\zztop\mescalero\whatwouldyoudo.flac

the optimization is done frequently.
i deleted ca. 15.000 titles during the last months. the database has now 386 mb for 156.000 titles. the behavior is unchanged.
i am using mm since ca 15 years, actual the gold version 4.1.24.1883.


to open the properties of one title (or group of titles), it takes 15 seconds before the mask is filled with all information.
after a change, the speed of the updates of the titles is ok again.

but to wait 15 seconds before the mask is populated is too long.

do you have an idea?

thanks best regards
stefan

Re: MM slow

Posted: Thu Jun 20, 2019 11:07 am
by Lowlander
STINO wrote:
Thu Jun 20, 2019 6:29 am
It takes 15 seconds before the mask is filled with all information.
What do you mean with mask? Do you mean it's that slow to load the values in the Properties window when you open a file's properties in the Music Collection?

Re: MM slow

Posted: Sat Jun 22, 2019 5:58 am
by STINO
hello dear lowlander,

mask is the property mask.
right click on a title
click on the last enty in the list (properties or shift+enter)
0 seconds mask opens
6 seconds album is displayed
8 seconds interpret is displayed
9 seconds genre is displayed
...
15 seconds title is displayed (sometimes it takes only 13 seconds :D )

when i close the file properties mask and reopen it for the same song, it takes the same long time.
but when i stay in the mask and browse to the next song, it works fast

do you have an idea?

thanks a lot - stefan

Re: MM slow

Posted: Sat Jun 22, 2019 12:10 pm
by Lowlander
That's odd behavior for the Music node. You may want to capture this in a debug log (step 4b) and attach the log to a Support Ticket: https://www.mediamonkey.com/forum/viewt ... p?f=1&t=69

Re: MM slow

Posted: Mon Aug 12, 2019 4:54 pm
by mm4me
I'm having the exact same issue, though not quite as bad. For me, the file properties box takes about 3-4 seconds. Still that's pretty tedious when you're doing a lot of metadata clean up.

I have about 87K music files in my database. I've cleaned the library, optimized, deleted and re-scanned, etc. None of that helps.

I've submitted this to the helpdesk, ticket #VDL-612-13639

The debug log for this operation is below if it helps anyone else. NOTE: I had to very slightly modify it because the forum thought I was posting external links.

Code: Select all

[19672] 16492 DB open SQL: SELECT PreviewStartTime, PreviewLength, CacheName, PreviewName, Copyright, Encoder, ISRC, InitialKey, Language, OrigLyricist, ParentalRating,PreGap, PostGap, TotalSamples, GaplessBytes, SignType, SignPart1, SignPart2, SignPart3, SignPart4, ContainerType, StreamCount, StreamInfo FROM Songs WHERE ID=? 
[19672] TGenThread.Create: ThreadName: OnReadArtists , Running Threads: Internal: 0, All: 34
[19672] Thread 'OnReadArtists' has started 12608
[19672] OpenQuery - Preparing query SELECT Artist, Lyrics FROM Artists WHERE Products=0 AND Roles=0 AND ID IN  (SELECT idArtist FROM ArtistsSongs WHERE TrackType in (5,6)) 
[19672] 12608 DB lock finished, took 351192.
[19672] OpenQuery - Preparing query SELECT Artist, Tracks, Albums, Authors, Conducts, Products, Lyrics, Roles FROM Artists 
[19672] TGenThread.Create: ThreadName: OnReadAlbumsAndGenres , Running Threads: Internal: 0, All: 35
[19672] Thread 'OnReadAlbumsAndGenres' has started 19532
[19672] 19532 DB lock finished, took 2249.
[19672] 19532 DB prepare SQL: SELECT IDGenre, GenreName FROM Genres
[19672] 19532 DB open SQL: SELECT IDGenre, GenreName FROM Genres 
[19672] 12608 DB open SQL: SELECT ParentalRating FROM ParentalRatings 
[19672] 12608 DB lock finished, took 3850.
[19672] 16492 DB open SQL: SELECT Lyrics, Comment FROM Songs WHERE SongsID=? 
[19672] 16492 DB open SQL: SELECT DISTINCT Artist FROM Songs WHERE IdAlbum=16702 and not Artist=(SELECT Artist FROM Albums Where ID=16702) 
[19672] 16492 DB lock finished, took 3097.
[19672] Forms: NormalizeTopMosts: Level: 0
[19672] Going 'OnReadAlbumsAndGenres'to make final callback 19532
[19672] DB: Deleting prepared query: SELECT IDGenre, GenreName FROM Genres 
[19672] Thread 'OnReadArtists'has finished 12608

Re: MM slow

Posted: Mon Aug 12, 2019 5:39 pm
by Peke
Hi,
I replied in Ticket but for me with a similar system it opens in less than second.

You can attach full compressed debug log in ticket so that we can see execution times.

Re: MM slow

Posted: Fri Aug 16, 2019 5:18 am
by Ludek
@mm4me:
I tested directly with your MM.DB (it has only 85K files) and the properties are really fast (always less than a half of a second)

The OnReadArtists thread reads just artist list in a background task -- so this is not slowing down opening the properties dialog.
It takes 3 seconds here also, but on the background once the dialog is already opened for 3 seconds.

Are you saying that the dialog is not usable for you until the "Thread 'OnReadArtists'has finished 5240" appears in the debug log ??

@STINO:
I also don't understand what do you mean by the mask, could you attach a screenshot or catch this in a video?

Re: MM slow

Posted: Tue Aug 20, 2019 10:00 am
by mm4me
For anyone else that runs into this problem, the issue turned out to be having the Override Skin theme option enabled.

Tools > Options > Skin > Override Skin theme with Windows System theme

After unchecking that, file properties opens reasonably fast now.