2013-08-24, 17:42
@Martijn, I posted before about this query below taking 2 minutes plus with skin widgets and basically making python unusable as it was always tied up running this query. I have since disabled skin widgets service due to this but saw this post and was wondering could you try this suggested change here or let me know what i would need to change in your code?
http://openelec.tv/forum/112-mysql-setup...uery#82913
This is the query i have an issue with and have seen others mention this as well
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))))
http://openelec.tv/forum/112-mysql-setup...uery#82913
This is the query i have an issue with and have seen others mention this as well
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))))