I've been using Kodi for a few years now with no problems until recently. I upgraded my Kodi Installs from 17.6 to 18.9 and have been having all kinds of issues on both of my Pi3's since the upgrade. I am using a MariaDB docker to keep a centralized database on my Unraid servers SSD Cache Drive. I currently have two windows machines (connected via ethernet to the same switch the server is connected to) and two Pi3's connected via Wifi. Neither Windows install has issues with Kodi or the SQL database.
The main issue I seem to run into is that kodi is slow or sometimes unresponsive when trying to browse my collection on the Pi's. Sometimes when trying to navigate to my TV shows I might have to wait a minute of more for it to load the TV show library. Other times it loads right away. I've had instances when trying to select a show that it will just freeze trying to load the season or episode view. I will get a spinning icon sometimes but at other times everything just becomes unresponsive for several minutes. At other times I can I can navigate fine around my TV library but when I got to browse my movie collection I will have to wait a couple of minutes for it to load. I have times where none of this happens and everything works as it should.
At this point I'm not sure where to start with troubleshooting this issue. I've tried the wait for network setting and have tried 10, 30 and 60 but it doesn't seem to fix the problem. I'm not sure if this is a Kodi problem, a MariaDB problem or a network problem. I've read about changing cache values in MariaDB but haven't done anything yet as I'm not sure what I would need to change. Any suggestions on things to troubleshoot would be great. I want to add a few more devices to my setup (Firestick 4K and possibly another Pi3) but it's kind of pointless if I can't get the others to work.