Long story short i’m trying to reduce how often the kodi instance hits the mySQL server. Original Thread
I’ve noticed that after installing AeonNox (best skin out there BTW) my kodi logs report an SQL update every 20 min.
14:44:53 T:2907079744 DEBUG: RunQuery took 4140 ms for 2308 items query: select * from movie_view WHERE ((movie_view.playCount IS NULL OR movie_view.playCount < 1))
14:45:00 T:2907079744 DEBUG: RunQuery took 4703 ms for 12841 items query: select * from episode_view WHERE ((episode_view.playCount IS NULL OR episode_view.playCount < 1))
14:45:03 T:2907079744 DEBUG: GetSongsByWhere query = SELECT songview.* FROM songview WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1))
14:45:03 T:2907079744 DEBUG: GetAlbumsByWhere query: SELECT albumview.* FROM albumview WHERE albumview.strReleaseType = 'album'
14:45:03 T:2907079744 DEBUG: GetAlbumsByWhere - query took 24 ms
14:45:04 T:2907079744 DEBUG: RunQuery took 13 ms for 0 items query: select * from musicvideo_view WHERE ((musicvideo_view.playCount IS NULL OR musicvideo_view.playCount < 1))Normally it would not matter but in my situation i need to greatly reduce the frequency of that call (once every 6/12 hours… ) I’ve done what i can to narrow down where the call is being made but seem to have hit a dead end.
I know its AeonNox because on a fresh install of Kido (confluence) the calls are not made. My best guess is its a dependency addon because when i install AeonNox and switch back to Confluence the calls are still being made. Im pretty sure “script.grab.fanart” is not the cause but i’m not too sure how to dig deeper at this point.
Would anyone be able to point me in the right direction?
Thanks,