PMS 1.24.3.5033 database locked

I haven’t been getting the DB locks but I do still see the slow query and held transaction to long … I found another thread where lots of users are complaining about this issue with an older version of PMS and there seems to be 2 fixes that I wonder if are still valid.1

  1. increase the SQLLite cache_size mine is current set to -2000
  2. Delete everything in the statistics tables