On Aug 2, 2009, at 3:52 PM, JJZolx wrote: > > radish;445192 Wrote: >> It's interesting, I have the latest 7.4 on my test server and it's >> OK, >> apart from the seemingly random CPU spikes from mysql. I haven't >> tried a >> rescan though, it's happily using an older db. Maybe I won't push my >> luck :) > > Rescans are working fine for here: Windows Server, Perl code, MySQL > 5.0.68, all file-per-track FLAC library. Scans are a little faster > than > 7.4 Trunk just before the merge, but not nearly as fast as I > expected if > all the optimizations that were made to the SQLite branch are now in > this one.
I am actually surprised how much slower MySQL is for scanning, the reason is every query has to go over a network/unix socket instead of being completely in-memory in the same process. MySQL is probably faster for some of the complex queries needed for browsing, but it can't compete in scan performance. _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
