Page 1 of 2

auto-playlists takes forever to load sometimes

Posted: Fri Jun 17, 2011 5:09 am
by beg
Hi,

Sometimes it takes forever for an autoplaylist to open. I attached to debug log snippets during these occasions:

00000558 85.25052643 [6176] Thread initialized 4800
00000559 85.25466919 [6176] 4800 DB open SQL: SELECT Songs.*
00000560 85.25466919 [6176] FROM Songs WHERE (Songs.SongPath like '%cd-compilations%')
00000561 85.49829102 [6176] 4532 DB open SQL: SELECT Playlists.*, (SELECT Count(*) FROM Playlists as Plst2 WHERE Plst2.ParentPlaylist=Playlists.IDPlaylist) AS cnt FROM Playlists WHERE Playlists.ParentPlaylist=3631 ORDER BY Playlists.PlaylistName
00000562 139.98991394 [6176] 4800 DB lock finished, took 192447028.
00000563 140.00610352 [6176] 4532 DB lock finished, took 191640930.
00000564 140.46220398 [6176] Thread has started 7968
00000565 140.46228027 [6176] Thread registered, going to initialize 7968

another huge "took" number here: (which I think has something to do with the time it took?)

00000000 0.00000000 [4788] Thread has started 3640
00000001 0.00014022 [4788] Thread initialized 3640
00000002 0.07402924 [4788] Going to make final callback 3640
00000003 30.00225258 [4788] Thread has started 460
00000004 30.00238228 [4788] Thread initialized 460
00000005 30.07626534 [4788] Going to make final callback 460
00000006 60.00486755 [4788] Thread has started 5372
00000007 60.00506592 [4788] Thread initialized 5372
00000008 60.08601761 [4788] Going to make final callback 5372
00000009 90.00671387 [4788] Thread registered, going to initialize 2484
00000010 90.07696533 [4788] Going to make final callback 2484
00000011 110.25587463 [4788] Going to execute format plug-in destructor.
00000012 110.25630188 [4788] 4792 DB lock successful.
00000013 121.03912354 [4788] 3628 DB lock finished, took 710908060.
00000014 121.04119110 [4788] 4792 DB exec SQL: UPDATE Songs SET PlayCounter=1,LastTimePlayed=40711.499383148, TrackModified=40711.499383148, PlaybackPos = 0 WHERE Id=487464
00000015 121.04238129 [4788] 4792 DB lock finished, took 3831.
00000016 121.04371643 [4788] Player: Next command started

I do have a huge database, but sometimes it takes over a minute! And this on my up to date workstation with brand new HD, not an old notebook..

cheers,
Bernhard

Re: auto-playlists takes forever to load sometimes

Posted: Fri Jun 17, 2011 12:02 pm
by rovingcowboy
your setting for mediamonkey background items might be set to low. and you having it that way when your doing things on the computer makes it rough to load fast.
or if you have half the amount of ram the system can hold it will be slow.

win xp only holds 3 gb's but win 7 is unlimited except by the motherboard makers.

get as much ram as you can get as that ram is also used for resource ram as of windows xp. so all the programs running
use that ram and use it up. since the new way of using ram for resource's the program developers of many other programs
do not make them use the bare min of ram they need so most new programs are ram hogs. mediamonkey is still being made to use only what it needs. but it needs more and more with all the new updated features in it.

also try a program called bill's2 process manager , its freeware and has the ablity to set the priority of programs to higher prioritys and keep it sat there after reboots.
don't adjust any of the windows system's stuff, but you can up mediamonkey to higher priority and get the background stuff
running faster that way.

of course even with all of that if you have some really hard rules for monkey to look for he is going to slow down a little to look for those rules.
:)

Re: auto-playlists takes forever to load sometimes

Posted: Fri Jun 17, 2011 10:15 pm
by beg
Hi,

I am using win 7 prof and 4 GB of ram.

in this case I was only using MM and waiting for the result.

An autoplaylist looking for all tracks in a certain folder - is that to be considered as a sophisticated rule?!

So this playlist in question had only one rule which was to look for a certain name in a path and list it's tracks. And there is only one folder matching. This is nothing I'd consider sophisticated in any way..

cheers,
Bernhard

Re: auto-playlists takes forever to load sometimes

Posted: Sat Jun 18, 2011 10:04 am
by nohitter151
Try to maintain your database (File > Maintain library) and defragment the database file.

Re: auto-playlists takes forever to load sometimes

Posted: Sat Jun 18, 2011 10:21 am
by beg
I do this regularly every week or so.. (since I am working with MM many hours every day..)

Re: auto-playlists takes forever to load sometimes

Posted: Mon Jun 20, 2011 3:02 pm
by rovingcowboy
okay since ram does not seem to be the trouble and the database is taken care of weekly then the only thing i can think of left to try is to get a registry cleaner for your operating system and run it. i use asuslogic's reg cleaner see if it works on your system its free and if that does the trick good. but if only helps a little. then i'm thinking you might need to defragment your registry also. so find one of those that works on your op system. there are some free ones. all they do is
remove the vacant lines in the registry and make it smaller in size which helps the system find the hotkeys faster, which helps with speed a little, its what they use to call tune up on the old 98 systems.

other then that stuff i can't think of anything that would slow it down so if none of that works make a debug log and send it in to support so they can try and figure it out. 8)

Re: auto-playlists takes forever to load sometimes

Posted: Tue Jun 21, 2011 4:08 pm
by rusty
Bernhard,

I can't replicate this issue. Does the problem only occur with an autoplaylist where criteria are 'Filename/Path' contains <drive>:/path ? I tried to replicate, but cannot.

On the other hand, as described at http://www.ventismedia.com/mantis/view.php?id=7985 , robojock indicated that he sometimes finds that 'Find more from same' results in delays of _minutes_ to open the files. I wonder if these two issues are related.

So far I haven't been able to replicate such huge delays in either case.

-Rusty

Re: auto-playlists takes forever to load sometimes

Posted: Sun Jul 03, 2011 7:15 am
by beg
Hm, did not check that, I'll try to check if it only happens with path/filename operations..

besides the fact that my win 7 installation is not very old, so registry should not be to much of a mess - why is the windows-registry such an issue useing MM4 portable?! how can win registry interfere with search result in MM?

Bernhard

Re: auto-playlists takes forever to load sometimes

Posted: Sun Jul 03, 2011 10:58 am
by nohitter151
beg wrote:Hm, did not check that, I'll try to check if it only happens with path/filename operations..

besides the fact that my win 7 installation is not very old, so registry should not be to much of a mess - why is the windows-registry such an issue useing MM4 portable?! how can win registry interfere with search result in MM?

Bernhard
Portable installations don't use the registry at all.

Re: auto-playlists takes forever to load sometimes

Posted: Sun Jul 03, 2011 11:21 am
by beg
that's what I thought and that's why I think that the idea of register-cleaning/tweaking is of no use in this matter..

Re: auto-playlists takes forever to load sometimes

Posted: Sun Jul 03, 2011 11:22 am
by nohitter151
beg wrote:that's what I thought and that's why I think that the idea of register-cleaning/tweaking is of no use in this matter..
Registry cleaning is of no use in any matter, really.

Re: auto-playlists takes forever to load sometimes

Posted: Sun Jul 03, 2011 12:21 pm
by beg
ok it is NOT related to file/path queries.

I just opened a fresh install of MM4 without any addons.
as fresh MM4 database with my music.
no background process going on.

Selecting an autoplaylist showing all 4-5* rated tracks and 5 different genres took about 30 seconds to load. (~2500 tracks a result)

how does the debugging work on MM4 portable? I installed the debug version, but I don't know how to get the logging information..

Bernhard

Re: auto-playlists takes forever to load sometimes

Posted: Sun Jul 03, 2011 12:22 pm
by nohitter151
You need to download the debugviewer program, it's all explained in a stickied post in the bug reports forum...

Re: auto-playlists takes forever to load sometimes

Posted: Sun Jul 03, 2011 12:28 pm
by beg
I know that, but I was not sure if it's the same procedure and programm for MM4 portable..

thx.

Re: auto-playlists takes forever to load sometimes

Posted: Sun Jul 03, 2011 12:29 pm
by nohitter151
beg wrote:I know that, but I was not sure if it's the same procedure and programm for MM4 portable..

thx.
yes, it is.