2017-02-16, 09:05
Can give some positive feedback. With a clean SD-card (LE 7.95.3) scanning is now at 100k songs with 135MB DB. No unplayed song queries, no mysql-slow errors!!
Scanning speed isn't glorious, but not that slow as expected:
About 12s per album
It feels like really these queries were the reason. Memory is slowing filling up during scanning, but somehow recovers again
Scanning speed isn't glorious, but not that slow as expected:
Code:
06:44:39.754 T:1763701664 DEBUG: Mysql commit transaction
06:44:52.128 T:1763701664 DEBUG: Mysql commit transaction
06:45:04.151 T:1763701664 DEBUG: Mysql commit transaction
06:45:16.227 T:1763701664 DEBUG: Mysql commit transaction
06:45:28.227 T:1763701664 DEBUG: Mysql commit transaction
06:45:40.930 T:1763701664 DEBUG: Mysql commit transaction
06:45:52.821 T:1763701664 DEBUG: Mysql commit transaction
06:46:04.248 T:1763701664 DEBUG: Mysql commit transaction
06:46:17.282 T:1763701664 DEBUG: Mysql commit transaction
06:46:19.473 T:1763701664 DEBUG: Mysql commit transaction
06:46:21.399 T:1763701664 DEBUG: Mysql commit transaction
06:46:23.557 T:1763701664 DEBUG: Mysql commit transaction
06:46:34.568 T:1763701664 DEBUG: Mysql commit transaction
06:46:46.117 T:1763701664 DEBUG: Mysql commit transaction
It feels like really these queries were the reason. Memory is slowing filling up during scanning, but somehow recovers again