arebe207;578064 Wrote: > Erland. Here is the log you requested attached. Note that after > enabling the debug log I selected a smaller playlist "legrand" (about > 150 tracks) first by mistake and it play correctly and quickly. I > stopped it and choose the playlist in question "good stuff" (1600 +/- > tracks)and of course it hung or ... The log file is below. Also my > setting for 'whole saved playlist' was and is set to 'no'. Thanks, > Richard > Ok it definitely seems to be the SQL statement that takes a lot of time even if it's only about to get 10 tracks from the database. The problem probably occurs only in larger libraries or with larger playlists.
Unfortunately, I suspect this means that it's caused by MySQL's limitation in joining "text" columns. The database structure was changed in 7.4 or 7.5 by Logitech and this caused this problem, it should work better with SQLite in 7.6 but with MySQL the problem also remains in 7.6 unless Logitech changes something. The my.tt performance optimization which you can read about in the following thread would have improved this on a computer, but it will probably just make it worse on a NAS: http://forums.slimdevices.com/showthread.php?t=60682 arebe207;578067 Wrote: > > I'm on a ReadyNAS Duo: > > Operating system: Netgear RAIDiator - EN - utf8 > Platform Architecture: sparc-linux > Perl Version: 5.8.8 - sparc-linux > MySQL Version: 5.0.24a-Debian_3.infrant1 > Do you know how much memory it have ? -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=82034 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
