HOW-TO:Share libraries using MySQL: Wiki Edition
#36
Folks i'm using mysql and this query seems to be causing issues with the skin widgets service and as a result its slowing the opening of addons. Anything that can be done to speed it up? I have a large video library.

15:49:09 T:139864761595648 DEBUG: RunQuery took 118872 ms for 324 items query: SELECT * FROM tvshowview WHERE (tvshowview.idShow IN (select tvshowview.idShow from tvshowview where (watchedcount > 0 AND watchedcount < totalCount) OR (watchedcount = 0 AND tvshowview.idShow IN (select episodeview.idShow from episodeview WHERE episodeview.idShow = tvshowview.idShow AND episodeview.resumeTimeInSeconds > 0))))
Reply


Messages In This Thread
RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - by moontan77 - 2013-05-18, 19:11
Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition2