I've just run some not very scientific tests to see whether this helps
at all. My library is a little under 25,000 tracks. The stats are below
after a full rebuild and vacuum.
The vacuuming makes a big difference to custom browse using custom scan
tags, and I'd be very happy if this became a standard plugin for doing
this. As I said before, it turns waits of a couple of minutes into
almost instant response (for the 1st use after restart). All menus then
give a sharp response.
I've been running with a buffer of 100MB. It seems that even custom
scan times are considerably improved, from around 3 hours for a full
scan to about 2 hours. Can this be my imagination?
I tried with and without the indexes and can't say I've notice any
difference (and I assume they get rebuilt anyway after a full rescan).
One question: Does the auto-vacuum setting 'stick' or not? I haven't
done enough trials to quite understand how this is expected to work. If
I tick it and Apply, the tick disappears.
Code:
--------------------
Vacuum auto_vacuum File Length Fragmentation
/var/lib/squeezeboxserver/cache/imgproxy.db 4.3 MB 0%
/var/lib/squeezeboxserver/cache/PluginCache-CustomBrowse.db
2.0 MB 0%
/var/lib/squeezeboxserver/cache/persist.db 409.1 MB
0%
/var/lib/squeezeboxserver/cache/PluginCache-SQLPlayList.db
0.3 MB 0%
/var/lib/squeezeboxserver/cache/library.db 71.1 MB 0%
/var/lib/squeezeboxserver/cache/cache.db 3.4 MB 0%
/var/lib/squeezeboxserver/cache/artwork.db 83.7 MB 0%
/var/lib/squeezeboxserver/cache/PluginCache-DatabaseQuery.db
0.2 MB 0%
/var/lib/squeezeboxserver/cache/PluginCache-MultiLibrary.db
0.1 MB 0%
--------------------
LMS 7.9 on VortexBox Midi running Xubuntu 14.04, FLACs 16->24 bit,
44.1->192kbps. Wired Touch + EDO, coax to Musical Fidelity M1 CLiC.
Wireless Xubuntu 14.04 laptop controls LMS via Chromium. Meridian
Explorer USB DAC to listen via Squeezelite on Vortexbox & other PCs as
required. Spare Touch in loft.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=101469
_______________________________________________
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta
