This is just to confirm that I have now repeated tests on my custom
browse / scan menus, and the following linux script (using sqlite3
installed on linux), run after a full scan with lms stopped, resolves
all my menu performance issues.
Code:
--------------------
sqlite3 /var/lib/squeezeboxserver/cache/persist.db "vacuum;"
--------------------
The menus now no longer take tens of seconds or minutes to run first
time, and never (so far!) cause a hiccup in playing music. These are
issues that have bothered me on and off for a couple of years. I'd be
interested to know if anyone else has had slow menu problems, whether
this fixes them, and if so why the custom scan seems to cause such
problems in persist.db. To give some idea, one of my custom scan menus
lists all Artists that have tracks in one multi-library (classical).
The top level menu therefore looks something like the following (I've
tried many variations and they all used to take about 4 minutes to run
1st time):
Code:
--------------------
select distinct
customscan_track_attributes.extravalue,customscan_track_attributes.value,
substr(customscan_track_attributes.value,1,1)
from customscan_track_attributes
join multilibrary_track on
customscan_track_attributes.track=multilibrary_track.track and
multilibrary_track.library=2
where
customscan_track_attributes.module='mixedtag' and
customscan_track_attributes.attr='ARTIST'
order by customscan_track_attributes.value asc
--------------------
I didn't believe this either, which is why I've run several tests to
repeat the process. :)
LMS 7.8 on VortexBox Midi running Xubuntu 13.10, FLACs 16->24 bit,
44.1->192kbps. Wired Touch + EDO, coax to Musical Fidelity M1 CLiC.
Wireless Xubuntu 12.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=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
