Ok, I thought I'd give it the quickest try I could, running a test on my dev machine (2017 MBP, SSD, 16GB RAM). Here are the results:
DBD::SQLite 1.58 (sqlite 3.22.0) Discovering files/directories: /Users/mh/Documents/SqueezeZeugs/flac100000 (107993 of 107993) Complete 00:00:19 Scanning new music files: /Users/mh/Documents/SqueezeZeugs/flac100000 (99663 of 99663) Complete 00:06:01 Building full text index (7 of 7) Complete 00:05:30 Create library views (2 of 2) Complete 00:00:00 Database Optimize (2 of 2) Complete 00:00:08 The server has finished scanning your media library. Total Time: 00:11:58 (Thursday, August 9, 2018 / 2:57 PM) Discovering files/directories: /Users/mh/Documents/SqueezeZeugs/flac100000 (107993 of 107993) Complete 00:00:17 Scanning new music files: /Users/mh/Documents/SqueezeZeugs/flac100000 (99663 of 99663) Complete 00:06:11 Building full text index (7 of 7) Complete 00:05:35 Create library views (2 of 2) Complete 00:00:00 Database Optimize (2 of 2) Complete 00:00:08 The server has finished scanning your media library. Total Time: 00:12:11 (Thursday, August 9, 2018 / 3:34 PM) DBD::SQLite 1.34_01 (sqlite 3.7.7.1) Discovering files/directories: /Users/mh/Documents/SqueezeZeugs/flac100000 (107993 of 107993) Complete 00:00:20 Scanning new music files: /Users/mh/Documents/SqueezeZeugs/flac100000 (99663 of 99663) Complete 00:08:43 Building full text index (7 of 7) Complete 00:00:21 Create library views (2 of 2) Complete 00:00:00 Database Optimize (2 of 2) Complete 00:00:15 The server has finished scanning your media library. Total Time: 00:09:39 (Thursday, August 9, 2018 / 3:08 PM) Discovering files/directories: /Users/mh/Documents/SqueezeZeugs/flac100000 (107993 of 107993) Complete 00:00:19 Scanning new music files: /Users/mh/Documents/SqueezeZeugs/flac100000 (99663 of 99663) Complete 00:08:55 Building full text index (7 of 7) Complete 00:00:30 Create library views (2 of 2) Complete 00:00:01 Database Optimize (2 of 2) Complete 00:00:17 The server has finished scanning your media library. Total Time: 00:10:02 (Thursday, August 9, 2018 / 3:20 PM) There clearly is an improvement in some parts of the newer code, but unfortunately a massive loss in another part. Now you could say I don't use FTS. But I do. That might show you that a decision pro or con can't easily be taken. Things are a bit more complicated than they might seem. Michael http://www.herger.net/slim-plugins - Spotty, MusicArtistInfo ------------------------------------------------------------------------ mherger's Profile: http://forums.slimdevices.com/member.php?userid=50 View this thread: http://forums.slimdevices.com/showthread.php?t=109325 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
