mherger wrote: > > Going further down the rabbit hole, you could analyze the queries and > > 'add additional indices' > Did you do so? Do you believe there's much room for improvement? > For general use cases, probably not (I'd assume that has been already done). However, OP doesn't specify which DB queries take that long, so it might be a plugin etc. Switching on DB logging and tracing the SQL statements might give some insights.
mherger wrote: > > I believe the slowness often is not in the DB queries themselves, but > eg. the page rendering (in case of the web UI). > The DB certainly can be the bottleneck, it was the case for my setup. See 'this post' (https://forums.slimdevices.com/showthread.php?110784-Odroid-HC1-as-a-server&p=952905&viewfull=1#post952905) for how much faster LMS became after migrating it to a platform with a better single-core performance (the benchmark mentioned is API-based, and DB-bound). Of course, rendering may add to that, but OP writes: > > This sadly causes quite noticable performance issues (15s+ delays on DB > Queries) > so that's what my answer was adressing. 'Various SW' (https://www.nexus0.net/pub/sw/): Web Interface | Playlist Editor / Generator | Music Classification | Similar Music | Announce | EventTrigger | 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=111312 _______________________________________________ Squeezecenter mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/squeezecenter
