2 Questions about 'Missing Artwork' in 'Files to Edit'

[dtsig]

I am doing this on current beta, 1651, and so am posting here instead of the regular help section. I don't have std version to test against.

I clicked on Music/Files to Edit/Missing Album Art and it came up with a message that I have to run create reports ... so i did.

1) when it runs it actually counts each track on the bottom of the screen. I have 145K + tracks and this takes a really really long time. Why doesn't it do a simple SQL query to get the count of tracks without artwork. There is a 'Covers' table and I would think that that table would have this information. Why not seconds instead of HOURS?

2) When the process completed I asked me if i wanted to see the report. I clicked YES and it then sat there for a while (10-15 minutes) and crashed. I sent the report. But much to my surprise when I restarted MMW and went to Edit/Missing Album Art it said I had to run the report again. Why is this??? I would think that at the time it asked if i wanted to see the report the info would have been saved.

[dtsig]

After 2 hours here is where we are 27265/145556

[Ludek]

Do you mean the
Music -> Files to Edit -> Unknown Artwork
?

It immediatelly shows 4281/9090 files in my DB (in less than half a second).

And yes, there is a simple query, this one in my case:
SELECT Songs.* FROM Songs WHERE Songs.Id NOT IN (SELECT Covers.IdSong FROM Covers) AND ( Songs.TrackType in (0,4,3) )

So I wonder what could slow it down on your DB, could you please generate debug log, item 4b here:
http://www.mediamonkey.com/forum/viewto ... ?f=6&t=341

[Ludek]

I see, you probably meant the
Music -> Files to Edit -> Inconsistent Artwork
?

Fixed as http://www.ventismedia.com/mantis/view.php?id=11122

[dtsig]

Currently at 70250/145556 after 5.5 hrs ... My guess it is slower than some because it is scanning physical tracks on the NAS. Still all this info should be in the DB.

Nope .. music/files to edit/Missing Album Art ... see below

By the way .. thanks for checking this quickly.

[rivorson]

Looks like you're using this third party script: Missing Album Art 2.0 [MM2+3]. It checks all files in your database that do have artwork registered then checks that each artwork file exists on the physical disk.

The function you want is 'Unknown Artwork', nine icons above the 'Missing Album Art' list that you're using. That one does a quick SQL search for all files with no artwork registered in MM and takes less than a second on my database of 30,000.

[dtsig]

Oh wow .. thanks for that. I don't even remember loading that. Must have been in the beginning.

It looks like unrooted a problem in one of the MMW auto lists so not all is bad. I will find from the developer whys and whats about his addon

Again .. thanks to you and Ludek both