Deleting a node in "Location" runs extremely slowly [18818]

Help improve MediaMonkey 5 by testing the latest pre-release builds, and reporting bugs and feature requests.

Moderator: Gurus

Timo_Beil
Posts: 659
Joined: Thu Sep 20, 2007 1:00 pm
Location: Germany, Northern Heath

Deleting a node in "Location" runs extremely slowly [18818]

Post by Timo_Beil »

Sometimes I have a local and the NAS location of my mediafiles in the Archive (by mistake, or when migrating).
In MM4 it takes a second, to remove an unwanted location.
In MM5 every single File is removed from Library, one after the other.
That takes about 4 hours for 40.000 track. Is there an faster way?
MM 5.0.3.2601 port
Last edited by Timo_Beil on Sun Feb 06, 2022 9:58 am, edited 1 time in total.
MM 2024.0.0.3005-port-DE, Win 11 pro, I7-6700, 16GB RAM, DB & Media>TrueNAS
Lowlander
Posts: 56465
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Deleting a node in "Location" runs extremely slowly

Post by Lowlander »

Are you viewing the files being deleted?
Timo_Beil
Posts: 659
Joined: Thu Sep 20, 2007 1:00 pm
Location: Germany, Northern Heath

Re: Deleting a node in "Location" runs extremely slowly

Post by Timo_Beil »

No, I don't.
Because the DB was migrated from an old "orphaned" MM4-installation (last MM4 version is portable), I just make a new clean installation.
Same results.
Deleting a node from Library (not from disk) in Location takes much more time than scanning for new files.
MM 2024.0.0.3005-port-DE, Win 11 pro, I7-6700, 16GB RAM, DB & Media>TrueNAS
Ludek
Posts: 4947
Joined: Fri Mar 09, 2007 9:00 am

Re: Deleting a node in "Location" runs extremely slowly

Post by Ludek »

Hi, testing this and seems fast for me.
I remember an issue like this when the particular DB was missing some DB indexes.

In that case the menu Maintain Library > 'Rebuild database' option re-creates the DB indexes (if that's the issue)
But please backup your current MM5.DB at first or open eSupport ticket and share link to your database (compressed %APPDATA%\MediaMonkey5\MM5.DB file)
Timo_Beil
Posts: 659
Joined: Thu Sep 20, 2007 1:00 pm
Location: Germany, Northern Heath

Re: Deleting a node in "Location" runs extremely slowly

Post by Timo_Beil »

Thanks for that hint.... but DB-reorg doesn't have any effect.

Removing is slow on 3 different PCs (Win 11) with clean install, fresh scanned Media folders, rebuild DBs...
DB and/or Mediafiles local and/or on NAS...
Same behaviour.
Scanning an new local folder with 1472 Files takes 2:11 min.
Removing takes 6:00 min (writing to the disk with the DB: 1600 B/s) :(

(I'll try an installed MM5 instead of portable)
EDIT: No change
EDIT: Same problem with Win 10 pro
EDIT: Same with official release MM 5.0.2.2531
MM 2024.0.0.3005-port-DE, Win 11 pro, I7-6700, 16GB RAM, DB & Media>TrueNAS
Ludek
Posts: 4947
Joined: Fri Mar 09, 2007 9:00 am

Re: Deleting a node in "Location" runs extremely slowly

Post by Ludek »

Then please catch this in debug log and attach to eSupport ticket, see item 4b here: https://www.mediamonkey.com/forum/viewt ... 30&t=86643
Timo_Beil
Posts: 659
Joined: Thu Sep 20, 2007 1:00 pm
Location: Germany, Northern Heath

Re: Deleting a node in "Location" runs extremely slowly

Post by Timo_Beil »

A lot of thanks to Ludek, who helped me patiently in discovering the reason.

My DB resides on the NAS for common use in different rooms.
The difference between MM4 and MM5 is the way, data are written to the DB.
MM4 hold them in Memory for a while, MM5 write them at once.
Therefore MM4 needs only 4 journal-files on the NAS for deleting 280 records. MM5 needs 280.
That traffic reduces the speed extremely.

In MM5 it's better to use a local DB.
MM 2024.0.0.3005-port-DE, Win 11 pro, I7-6700, 16GB RAM, DB & Media>TrueNAS
Ludek
Posts: 4947
Joined: Fri Mar 09, 2007 9:00 am

Re: Deleting a node in "Location" runs extremely slowly [Solved]

Post by Ludek »

FYI: Tracking as https://www.ventismedia.com/mantis/view.php?id=18818
For the next build 5.0.3.2607 there will be INI switch to enable in memory caching (details in the Mantis issue).
Post Reply