I have the same problem. I put the debug logging on and this query seems to take forever in MySQL:
SELECT COUNT( * ) FROM tracks me LEFT JOIN tracks_persistent persistent ON persistent.url = me.url WHERE ( ( audio = ? AND ( persistent.lastplayed IS NULL OR persistent.lastplayed < ? ) ) ): '1', '1251308488' Running latest nightly now: Squeezebox Server Status Version: 7.4 - r28286 @ Wed Aug 26 07:38:14 PDT 2009 Hostname: trane Server IP Address: 192.168.1.3 Server HTTP Port Number: 9000 Operating system: SuSE - EN - utf8 Platform Architecture: x86_64-linux Perl Version: 5.8.8 - x86_64-linux-thread-multi MySQL Version: 5.0.26 Total Players Recognized: 1 Library Statistics Total Tracks: 129,297 Total Albums: 14,702 Total Artists: 2,756 Total Genres: 136 Total Playing Time: 10062:07:50 Cheers, Kari -- lemppari ------------------------------------------------------------------------ lemppari's Profile: http://forums.slimdevices.com/member.php?userid=1775 View this thread: http://forums.slimdevices.com/showthread.php?t=66669 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
