OK, looks like I'm getting somewhere.  First, as far as my first problem
with the changes not taking effect... never mind.  I use the Dynamic
Playlists a lot at work with XMMS playing the stream.mp3 on my Linux
workstation.  I've found that I have to start playing the stream with
XMMS or else anything I do in Squeezecenter as far as playing music
acts on my squeezebox at home.  So even when I say I was starting fresh
I had already started playing in XMMS, which picked up from the last
thing I was playing, and that in most cases is the Dynamic Playlist.  I
did some testing and found that if I make adjustments to the includes
and excludes first, save the changes, then start playing it works fine.


With the pausing issue, I turned on the suggested debug option and
closely watched my system while playing.  Every time the music paused
mysqld CPU usage would jump to 90+% (as I mentioned before) and just as
the music resumed I would see an entry in the squeezecenter server.log
like the following:
> [08-06-05 16:27:59.5225]
> Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (854) Executing and
> collecting: select tracks.url from tracks join genre_track on
> tracks.id=genre_track.track join genres on genre_track.genre=genres.id
> left join dynamicplaylist_history on
> tracks.id=dynamicplaylist_history.id where audio=1 and
> dynamicplaylist_history.id is null and genres.name in ('Blues','Rock')
> and not exists (select * from tracks t2,genre_track,genres where
> t2.id=tracks.id and tracks.id=genre_track.track and
> genre_track.genre=genres.id and genres.name in
> ('Bootleg','Demo','DVD','OfficialBoot','Sessions'))group by tracks.id
> order by rand() limit 10;
Also, as I mentioned I'm doing this from work a lot of times, so maybe
I haven't paid that close of attention before today, but I originally
said the pauses happened every 5 songs or so.  It is actually happening
every 4-5 minutes, so depending on the song timing it happens almost
every song, or every other song.


-- 
soxfan
------------------------------------------------------------------------
soxfan's Profile: http://forums.slimdevices.com/member.php?userid=5697
View this thread: http://forums.slimdevices.com/showthread.php?t=48556

_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins

Reply via email to