I thought I'd post some real-world scanning times of 7.6.1 beta with WAL and compare them to those of 7.5.6. These were run using my actual Flac library of 32,746 Flac files, not a test library. 7.6.1 with MySQL appears to no longer have a problem with pre-caching artwork, so I could also compare it directly to 7.5.6 and the standard configuration of 7.6.1 with SQLite.
I ran two full clear & rescans of the library in three server configurations. All library settings on the three servers were identical. The first run (ending 9:39 PM) may not have benefited from system caching as much as the others. Music files only, no playlists. Only one scan was run at a time and the server was doing nothing else during the scans. The system: Dual-Core Xeon E3210 @ 3.16 GHz 4 GB memory Windows Server 2003 SP2 MySQL 5.0.68-enterprise-gpl-nt MySQL is optimized by throwing a lot more memory at it than the High memory config of the server run by SBS 7.5. Summary, total scan times: 7.5.6 r32834 (MySQL) #1 18:38 7.5.6 r32834 (MySQL) #2 18:32 7.6.1 r33038 with SQLite #1 35:27 7.6.1 r33038 with SQLite #2 34:18 7.6.1 r33038 with MySQL #1 20:05 7.6.1 r33038 with MySQL #2 18:33 Details of each run: (The first scan run was 7.6.1 with MySQL, so it no doubt benefited the least from any OS level file caching. Without this caching, I think would add approximately 1:30 to 2:00 to the times.) 7.5.6 r32834 (MySQL) #1 Directory Scan (32746 of 32746) Complete 00:10:51 Playlist Scan Complete 00:00:00 Merge Various Artists (2638 of 2638) Complete 00:00:06 Artwork Scan (2715 of 2715) Complete 00:07:41 The server has finished scanning your music collection. Total Time: 00:18:38 (Wednesday, August 10, 2011 / 10:00 PM) #2 Directory Scan (32746 of 32746) Complete 00:10:46 Playlist Scan Complete 00:00:00 Merge Various Artists (2638 of 2638) Complete 00:00:09 Artwork Scan (2715 of 2715) Complete 00:07:37 The server has finished scanning your music collection. Total Time: 00:18:32 (Wednesday, August 10, 2011 / 11:42 PM) 7.6.1 r33038 with SQLite #1 Discovering files/directories: D:\slim\65\music (1 of 1) Complete 00:00:00 Discovering files/directories: E:\Flac (36587 of 36587) Complete 00:00:32 Scanning new files: E:\Flac (32746 of 32746) Complete 00:29:36 Discovering playlists: D:\slim\65\playlists (1 of 1) Complete 00:00:00 Pre-caching Artwork (2878 of 2878) Complete 00:05:19 The server has finished scanning your music collection. Total Time: 00:35:27 (Wednesday, August 10, 2011 / 10:38 PM) #2 Discovering files/directories: D:\slim\65\music (1 of 1) Complete 00:00:00 Discovering files/directories: E:\Flac (36587 of 36587) Complete 00:00:34 Scanning new files: E:\Flac (32746 of 32746) Complete 00:28:55 Discovering playlists: D:\slim\65\playlists (1 of 1) Complete 00:00:00 Pre-caching Artwork (2878 of 2878) Complete 00:4:49 The server has finished scanning your music collection. Total Time: 00:34:18 (Thursday, August 11, 2011 / 12:17 AM) 7.6.1 r33038 with MySQL #1 Discovering files/directories: D:\slim\67\music (1 of 1) Complete 00:00:00 Discovering files/directories: E:\Flac (36587 of 36587) Complete 00:00:18 Scanning new files: E:\Flac (32746 of 32746) Complete 00:13:45 Discovering playlists: D:\slim\67\playlists (1 of 1) Complete 00:00:00 Pre-caching Artwork (2878 of 2878) Complete 00:06:02 The server has finished scanning your music collection. Total Time: 00:20:05 (Wednesday, August 10, 2011 / 9:39 PM) #2 Discovering files/directories: D:\slim\67\music (1 of 1) Complete 00:00:00 Discovering files/directories: E:\Flac (36587 of 36587) Complete 00:00:20 Scanning new files: E:\Flac (32746 of 32746) Complete 00:13:34 Discovering playlists: D:\slim\67\playlists (1 of 1) Complete 00:00:00 Pre-caching Artwork (2878 of 2878) Complete 00:4:38 The server has finished scanning your music collection. Total Time: 00:18:33 (Thursday, August 11, 2011 / 12:45 AM) -- JJZolx ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=89513 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
