MeSue;335939 Wrote: > Thanks. You got the specs right on the HP server, but mine is upgraded > to 1 GB memory. According to "Spotlight on Windows" (a performance > monitor), I have a around 200 MB free memory. Whether this is true > through the whole scanning process, I don't know, as I only checked it > just now. > 1 GB spontaneously sounds like it should be enough.
The normal time of the queries that takes over 30 minutes in your setup is maximum a few seconds, so it feels like something is seriously wrong somewhere. One thing that might be worth a try is to temporarily install the Database Query plugin and look at the result of its "Custom Scan Statistics" query. This should give me some kind of idea if there is anything wrong with your Custom Scan data. I would not try the "Custom Scan Inconsistency/Problems" query, because that will probably take hours to execute in your setup. It might also be interesting to temporarily enable TrackStat debug logging in "SqueezeCenter Settings/Logging" and then issue a "Refresh statistic after rescan" from the "SqueezeCenter Settings/Plugins/TrackStat/Backup Restore Clear" section of TrackStat setting pages. Post the TrackStat log entries in the SqueezeCenter log after it has finished. The reason this is interesting is that TrackStat runs similar queries, and if those also takes long time it would indicate a general performance problem of MySQL in your setup. MeSue;335939 Wrote: > Custom Scan isn't required for Trackstat ratings? I thought it was. If > it's not, then I will just disable Custom Scan. > It's only needed if you use the iTunes, Music IP or Amarok integration provided by TrackStat to sync rating between these applications and SqueezeCenter. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library 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=51894 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
