2018-03-12, 08:59
Nice post OP. I tried some of these on my Synology's MariaDB settings. While I didn't record before times, I think this really helps the beat the slow query issue. Results come back almost instant from a large library. If confirmed by others, this should be in the wiki.