Philip Meyer;446431 Wrote: > This appears to be taking longer in 7.4/trunk since noweb-sqlite changes > have been merged in. > > It appears to be scanning every file, rather than only files that have > newer timestamps (the scanner log is reporting that it is scanning every > file).
Scanning is slower with MySQL than with SQLite. With the SQLite branch I was seeing both full scans and new & changed scans about 30-40% faster than the MySQL scans running on the same machine. Each file has to be looked at, but not really "scanned" in the sense of reading tags. At a minimum, every file found in the music folder must be looked up in the database. If the file isn't found then it's new and must be fully scanned. If either the file's timestamp or size doesn't match that on record in the database, then it's changed and must be fully scanned. The logging is the only thing that's really different, as every file is logged during any kind of scan. I don't recall for certain, but I thought that was changed in the noweb-sqlite branch because it affected the overall speed of the scans. -- JJZolx Jim ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=66419 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
