[moontan77]

folks, I'm having issues where addons are sometimes slow to start (taking 2 minutes to open) and the skin widgets service is possibly the cause.

I'm using openelec 3.0.3 x64 on an acer revo 3610 (have been having this issue since last year at least). Other things to note are that i use mysql and samba shares, and have a big library. This is a client pc, main xbmc runs on a headless pc.


I went through the following steps:

1) Installed Refocus Big skin and rebooted (this install skin.widgets and a few other scripts). When it restarted, i tried opening the iplayer addon which opened ok. Then i tried to open the Irish tv addon which took about 2 minutes 2 open.

Log: http://xbmclogs.com/show.php?id=20082

2) I then deleted the next show aired script and rebooted. When it restarted, i tried opening the iplayer addon, and it took about 2 minutes to open.

Log: http://xbmclogs.com/show.php?id=20108

3) I then deleted the randomlastitems script and rebooted. When it restarted, i tried opening the iplayer addon, and it took about 2 minutes to open.

Log: http://xbmclogs.com/show.php?id=20111

4) I then deleted the skin.widgets service and rebooted. When it restarted, i tried opening the iplayer addon, and it opened straight away. Rebooted about 5 times, and iplayer and the other addons i tried opened straight away.

Log: http://xbmclogs.com/show.php?id=20113


5) Reinstall Refocus Big (and in turn its dependencies), deleted skin.widgets service and rebooted. When it restarted, i tried opening the iplayer addon, and it opened straight away. Rebooted about 5 times, and iplayer and the other addons i tried opened straight away.

Log: http://xbmclogs.com/show.php?id=20119

Note, I have recentlyadded set to 100 instead of 10 on this client pc. And changed it back to 10 following a suggestion on IRC, unfortunately this made no difference.


When the addons are slow to open and eventually do open, they work fine for a while but if i go back to them later in an hour or so, they are slow again to open.

Scroll down towards the end of each log for the opening of the addons.


Any suggestions as to what might be causing issues for the skin widgets service?

Edit: from log 3 line 861, must be due to the amount of tv episodes!

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))))


thread here has the same issue:
http://forum.xbmc.org/showthread.php?tid=148657