Tthe biggest reasons for moving to SQLite are the pitfalls of running MySQL from Squeezebox Server. Installation problems, permission problems, virus scanner headaches, etc. It's especially difficult to manage on Windows, but is compounded by having to support several different platforms.
SQLite should handle the vast majority of libraries just fine. Most people don't have 300,000 tracks, or even 30,000. Having the option of using MySQL for large libraries, though, should handle those cases. My library is about 27,000 tracks and I'm running 7.6 with SQLite without any major problems. However, there is one very annoying thing the first time I try to do anything after restarting the server: There's always a _long_ delay of 15-20 seconds before getting any kind of response. I think SbS may be schlepping the whole SQLite database into memory when this happens. I expect to switch to MySQL when it's fixed on Windows. -- JJZolx Jim ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=78527 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
