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
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]
[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
[/code]