Hi, I'm running slimserver with a mysql server backend. Today all of a sudden I started getting dropouts in playback. A bit of looking around revealed the cause was due to this SQL query being emitted every minute or so:
2006-03-24 14:12:12.6784 Running SQL query: [SELECT DISTINCT albums.id AS id,albums.title AS title,albums.titlesort AS titlesort,albums.contributor AS contributor,albums.compilation AS compilation,albums.year AS year,albums.artwork_path AS artwork_path,albums.disc AS disc,albums.discc AS discc,albums.musicmagic_mixable AS musicmagic_mixable FROM tracks, albums WHERE albums.id = tracks.album ORDER BY tracks.age desc, tracks.disc, tracks.tracknum, tracks.titlesort LIMIT 100] I ran this query in isolation and verified it takes 1.5s to execute, and this is enough for a dropout in my setup (SB1/WAV). I had a quick look in the code but couldn't find where this query is being generated. Anyone know what the query is doing and whether it's possible to disable it? Thanks, Nico -- nico ------------------------------------------------------------------------ nico's Profile: http://forums.slimdevices.com/member.php?userid=672 View this thread: http://forums.slimdevices.com/showthread.php?t=22401 _______________________________________________ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
