2018-03-21, 14:36
(2018-03-21, 08:48)ventolin Wrote:Yes this is a running theme within the team as MYSQL support was added, when really the team wanted a full client to client approach in the long term. Nobody wrote that yet so, we are kind of stuck with the old style central server approach which nobody really supports.(2018-03-20, 23:44)marantz Wrote: just tested this on mariadb 10.2.13 and SET SESSION optimizer_switch = 'derived_merge=off'; had no effect on performanceGood to know. I had bad (and similar) experiences when I switched to MariaDB and was met with very hostile answers along the lines of "mysql db backend is barely supported, mariadb definitely not" in #xbmc on freenode when I asked about it.
I might give it another go this weekend just to see if things have improved with mariadb 10.1. Thanks!