mherger wrote: > > DB Optimizer is a plugin for LMS to improve it's database performance > > and memory use. > > More information can be found 'on the homepage' > > (https://www.nexus0.net/pub/sw/lmsdboptim/). > > Would you have a rough idea what parts of LMS' functionality would take > > advantage of which tweak? As Erland said it might be interesting to > "backport" some of these to the main line product.
Anything accessing the DB should benefit. I've listed the various tweaks on the homepage (with links to the relevant SQLite docs): Some correct oversights (e.g. library uses temp_store = MEMORY, persist does not; artwork always get 80MB cache even at "Maximum") or bit rot (e.g. I suspect the 4GB DB cache is a result of SQLite switching from 1KB pages to 4KB some years ago). Others are IMHO no-brainers (PRAGMA optimize before shutdown, multi-threading) Database cache sizes are really unbalanced (2*8MB+1MB -> 3*80MB -> 4GB+80MB) mmap might be more complex to assess, but for anything not Windows is seems great (25% less memory on my setup, plus (probably) better performance) 'Various SW' (https://www.nexus0.net/pub/sw/): Web Interface | TUI | Playlist Editor / Generator | Music Classification | Similar Music | Announce | EventTrigger | Chiptunes | LMSlib2go | ... 'Various HowTos' (https://www.nexus0.net/pub/documents/LMS/): build a self-contained LMS | Bluetooth/ALSA | Control LMS with any device | ... ------------------------------------------------------------------------ Roland0's Profile: http://forums.slimdevices.com/member.php?userid=56808 View this thread: http://forums.slimdevices.com/showthread.php?t=114067 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
