mherger wrote: > > But you should be able to use MySQL, if you wanted to give it a try. > Would be interesting if that would turn out to be faster. One advantage > > certainly would be that it would use another core on today's multi-core > > systems, > I'd speculate MySQL won't be faster. There are a couple of methods to exploit multi-threading. Ignoring processing several SQL queries at once (as LMS sends queries sequentially) and more esoteric ones (data sharding etc.), this basically leaves intra query parallelism, e.g. - if a query has subqueries, processing those in parallel - under certain (limited) conditions, certain ops during query processing can be parallelized (e.g. higher level (table scans etc., usually requires explicit declaration), lower level (e.g. sorting results)) MySQL will be better at this, but SQLite actually supports a (very) limited form of the latter approach (iirc sorting results, maybe more?). Multi-threading is, however, disabled by default. My plugin enables it (2 threads), but atm I have no idea if it is ever used. On the flip side, SQLite has an advantage in having siqnificantly less overhead (no server etc.) and no intra-process communication. And there is a real question if LMS even uses single queries worth parallelizing (in terms of both complexity and data volume), as this generates overhead of it's own (thus, SQLite has built-in heuristics to decide how many threads it uses for a query).
Nevertheless, I agree, if anyone bothers to invest time in actually benchmarking this, it'll interesting to the see the results. mherger wrote: > > SQLite is running inside the single LMS thread. > I don't think this prevents SQLite from launching additional threads if it is so inclined. '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
