Interesting... I finally got a full rescan with SQLite comparable to the
MySQL performance in 7.6.1. A little faster, actually. I got it by
stopping the server and running a VACUUM operation on all three of the
databases.

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:36
Scanning new files: E:\Flac  (32746 of 32746)  Complete 00:14:18
Discovering playlists: D:\slim\65\playlists  (1 of 1)  Complete
00:00:00
Pre-caching Artwork   (2878 of 2878)   Complete 00:03:03
The server has finished scanning your music collection.
Total Time: 00:17:57 (Thursday, August 11, 2011 / 11:03 PM)

http://www.sqlite.org/lang_vacuum.html

Maybe the db files were fragmented. We'll see whether or not this needs
to become a regular part of server maintenance.


-- 
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

Reply via email to