dip;550997 Wrote: > I have tried the test version, but there was almost no improvement. I > enclose my server.log file. > Could you try to enable "debug" logging on "database.sql", I'd like to see what it does between the row saying "Getting item data for 200 items" and "Returning 200 items".
If it produces something like 200 or more SQL statements log entries between these rows in the log, there is still something I've missed. It's the time between these two rows that should be a lot faster in the newer version. If it works correctly, it should run a single SQL statement retrieving all 200 tracks or albums requested. It could be that running this single SQL statement just takes the same time in a large library as running 400 smaller SQL statements, in that case the changes didn't help in a larger library. However, it could also be that some setting causes it to run more SQL statements in your library than in mine. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
