Philip Meyer;595686 Wrote: > I don't think it can really be claimed that SQLite significantly > improves scanning speed either. There's a lot of other performance > improvements in 7.6, and as MySQL doesn't work, it's not comparable. > MySQL, and the DB access code that SBS executes, could be improved as > well.
I think that when (or if) MySQL starts working reliably again it will be proven that SQLite is faster doing scans. Since the new & changed scans have been moved internally instead of launching the external scanner they're insanely fast. Just now, to do a new & changed scan on my 30k track library with two new albums took just 9 seconds. Some other areas that SQLite improves on, that won't be necessarily be noticed by users, but will have a positive net effect on their experience and will reduce support calls are in the installation. Squeezebox Server's instance of MySQL Server won't have to be installed as a Windows service (although it never had to be in the first place). There will also be no need to create MySQL file exceptions, or all the associated headaches with firewall issues it causes. One thing that I _still_ see, though, is that BBF (big brain fart) every once in a while using SQLite. Maybe once a week or so I'll go to browse the library in the web interface and it will take about 20-25 seconds before a page will appear. After the brain fart everything works normally. -- JJZolx ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=83909 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
