JJZolx;303532 Wrote: > When SlimServer 6.0 came out, with its move to MySQL for its dbms, it > was faster on many systems with large libraries, slower on some systems > with small libraries, but very much slower on the ReadyNAS. It was > explained by Infrant that the ReadyNAS CPU architecture was uniquely > unsuited to running MySQL. This is something to bear in mind when optimizing.
I've also noticed that the MySQL performance on some more complex queries can differ a lot between Windows and Linux. I've also seen that it can differ a lot between different 5.0.x versions of MySQL. SqueezeCenter currently uses 5.0.21 while there are a lot newer 5.0.x versions available. So when checking optimizations, be really sure that you use the MySQL version bundled with SqueezeCenter and run it on the platform where you are going to use it later. Optimizing the performance when running SqueezeCenter on a Mac/PC doesn't have to result in better performance when you later are running it on ReadyNAS. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.homeip.net/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=45261 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
