Hi, finally I've a solution. Maybe it's not the right one but it works for me. I comment out the "AND contributor_track.role IN (1, 2)" (Queries.pm). This reduce the execution time (on my PC) from 3 to 0.05 seconds. So now my ReadyNAS DUO CPU has time to breathe.
Regards maggi68 SELECT albums.title as album, contributors.name, tracks.coverid, tracks.id, tracks.remote, tracks.title FROM tracks JOIN contributor_track ON contributor_track.track = tracks.id JOIN contributors ON contributors.id = contributor_track.contributor JOIN albums ON albums.id = tracks.album WHERE tracks.id IN (...) -- AND contributor_track.role IN (1, 2) GROUP BY tracks.id -- maggi68 ------------------------------------------------------------------------ maggi68's Profile: http://forums.slimdevices.com/member.php?userid=32446 View this thread: http://forums.slimdevices.com/showthread.php?t=81733 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
