2017-02-22, 14:47
I have a test db file from another long standing user with 140k songs, but some testing only works when you have the actual music files behind it which obviously I don't. You collection is certainly large, but you are not alone. However you are the only person I have on a RPi with that size of lib ready to do some testing :p
So MariaDb faster than MySQL 5.5, interesting
We did have some issues reported with MariaDB some versions back, I believe they are fixed but interested to see what happens for you.
Still eager to know about the unplayed songs query and memory issues. Maybe it all goes away with MariaDB, and not having LDP running during scanning? As I said v17.1 will have a fix for the inefficient unplayed songs query - no longer fetching the entire songs table into local memory just to give 10 random ones!
So MariaDb faster than MySQL 5.5, interesting
We did have some issues reported with MariaDB some versions back, I believe they are fixed but interested to see what happens for you.
Still eager to know about the unplayed songs query and memory issues. Maybe it all goes away with MariaDB, and not having LDP running during scanning? As I said v17.1 will have a fix for the inefficient unplayed songs query - no longer fetching the entire songs table into local memory just to give 10 random ones!