MillmoorRon;143015 Wrote: > This is (the end) of my log file after starting a "not played songs" > dynamic playlist and trying (mostly unsuccessfully) to skip a few > tracks. > > Does this tell you anything? > It looks like it takes about 4 seconds for DynamicPlayList to retreive a new track for a TrackStat playlist. You are running one of the playlists that should be pretty fast, so there are probably other TrackStat playlists that takes a lot more than 4 seconds.
TrackStat also retreives 50 tracks even though DynamicPlayList only needs one. The reason for this is that some random selection code is done in the perl code instead of int the SQL query. I think there is a lot of optimizing potential in this part of the code, it really looks like I didn't have performance in mind when I wrote it. I will put an entry on the TrackStat wish list to optimize this. All this probably means that if you click the "next track" button it will take about 4 seconds until you see any response and the new track starts to play. Is this how it feels ? MillmoorRon;143703 Wrote: > Out of interest, what kind of hardware problem might influence the > performance of SQL on my system? What hardware do you have ? How many tracks do you have in your library ? The performance can be affected by: - processor speed - memory size - harddisk speed It's impossible to say which component that is critical without further investigation/knowledge of the system. On my AMD XP2500+ with 1GB memory and around 3000 tracks in the library it takes less than a second to switch to next track. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist) , 'DynamicPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist), 'Custom Browse' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse) and 'RandomPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist) plugins) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=28195 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
