[SOLVED] MM Properties opens slowly

Get answers about using the current release of MediaMonkey for Windows.

Moderator: Gurus

STINO
Posts: 3
Joined: Sat Jan 26, 2019 2:32 pm

[SOLVED] MM Properties opens slowly

Post by STINO » Sat Jan 26, 2019 2:53 pm

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

Lowlander
Posts: 46156
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: MM slow

Post by Lowlander » Sat Jan 26, 2019 3:04 pm

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)?
Lowlander (MediaMonkey user since 2003)

STINO
Posts: 3
Joined: Sat Jan 26, 2019 2:32 pm

Re: MM slow

Post by STINO » Thu Jun 20, 2019 6:29 am

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

Lowlander
Posts: 46156
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: MM slow

Post by Lowlander » Thu Jun 20, 2019 11:07 am

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?
Lowlander (MediaMonkey user since 2003)

STINO
Posts: 3
Joined: Sat Jan 26, 2019 2:32 pm

Re: MM slow

Post by STINO » Sat Jun 22, 2019 5:58 am

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

Lowlander
Posts: 46156
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: MM slow

Post by Lowlander » Sat Jun 22, 2019 12:10 pm

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
Lowlander (MediaMonkey user since 2003)

mm4me
Posts: 2
Joined: Mon Aug 12, 2019 4:43 pm

Re: MM slow

Post by mm4me » Mon Aug 12, 2019 4:54 pm

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

Peke
Posts: 12441
Joined: Tue Jun 10, 2003 7:21 pm
Location: Serbia
Contact:

Re: MM slow

Post by Peke » Mon Aug 12, 2019 5:39 pm

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.
Best regards,
Pavle
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
How to add SCREENSHOTS to forum

Ludek
Posts: 3036
Joined: Fri Mar 09, 2007 9:00 am

Re: MM slow

Post by Ludek » Fri Aug 16, 2019 5:18 am

@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?

mm4me
Posts: 2
Joined: Mon Aug 12, 2019 4:43 pm

Re: MM slow

Post by mm4me » Tue Aug 20, 2019 10:00 am

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.

Post Reply