2014-10-12, 05:23
Hello folks!
First of all, this is my first post, so please be gentle. If this is in the wrong section of the forum, please let me know how to move it or have a moderator do it.
I run XBMCbuntu on an i5 Intel NUC as my HTPC and have been immensely pleased so far. I would like to thank the developers behind this amazing piece of software.
PROBLEM:
---------------
I was having some issues with my library updates slowing down over a period of time, mostly the 'Clean Library' feature. My library has ~200 movies and ~400 TV show episodes with more being slowly added via automated downloads. I have the XBMC Library auto update plugin which automatically cleans and updates the library every 24 hours but then I started noticing that the clean library step takes increasingly longer with each passing day.
To attempt to fix this, I would re-create my library (by deleteting MyVideos.db and scanning again), and the clean library step would be fixed taking 3-5 seconds to complete. But as days pass, it would again slow down and take minutes instead of seconds.
I recently configured my XBMC installation to use a MySQL database in the hopes of resolving this issue but it persisted. Today, I decided to spend some time and find out the reason behind this behavior.
ISSUE:
---------
I discovered that in the 'files' table of the MyVideos database, there are entries that have the strFileName field set to URLs from plugins. There are hundreds of such entries which correspond to my usage of different video plugins. Below are some examples:
plugin://plugin.video.tvondesizonexl/?videoLink=http%3A%2F%2Fwww.videoweed.es%2Ffile%2F2085c067a210b
plugin://plugin.video.ign_com/?url=http%3A%2F%2Fwww.ign.com%2Fvideos%2F2014%2F10%2F02%2Fmiddle-earth-shadow-of-mordor-6-tips-for-mastering-the-nemesis-system&mode=playVideo
I manually removed a few hundred of these entries and immediately noticed that the clean library step started speeding up again as I kept on removing these entries. I am fairly confident that this is causing the issue of slowing down the clean library step, at least in my case. I suspect that the XBMC logic finds these URLs and attempts to verify those files exist or something like that, thereby spending time during the clean library step.
These are plugin URLs and not files per se, so why are they being stored in the database?
Hope this is helpful and a developer can figure this out.
Thank you.
Akash
First of all, this is my first post, so please be gentle. If this is in the wrong section of the forum, please let me know how to move it or have a moderator do it.
I run XBMCbuntu on an i5 Intel NUC as my HTPC and have been immensely pleased so far. I would like to thank the developers behind this amazing piece of software.
PROBLEM:
---------------
I was having some issues with my library updates slowing down over a period of time, mostly the 'Clean Library' feature. My library has ~200 movies and ~400 TV show episodes with more being slowly added via automated downloads. I have the XBMC Library auto update plugin which automatically cleans and updates the library every 24 hours but then I started noticing that the clean library step takes increasingly longer with each passing day.
To attempt to fix this, I would re-create my library (by deleteting MyVideos.db and scanning again), and the clean library step would be fixed taking 3-5 seconds to complete. But as days pass, it would again slow down and take minutes instead of seconds.
I recently configured my XBMC installation to use a MySQL database in the hopes of resolving this issue but it persisted. Today, I decided to spend some time and find out the reason behind this behavior.
ISSUE:
---------
I discovered that in the 'files' table of the MyVideos database, there are entries that have the strFileName field set to URLs from plugins. There are hundreds of such entries which correspond to my usage of different video plugins. Below are some examples:
plugin://plugin.video.tvondesizonexl/?videoLink=http%3A%2F%2Fwww.videoweed.es%2Ffile%2F2085c067a210b
plugin://plugin.video.ign_com/?url=http%3A%2F%2Fwww.ign.com%2Fvideos%2F2014%2F10%2F02%2Fmiddle-earth-shadow-of-mordor-6-tips-for-mastering-the-nemesis-system&mode=playVideo
I manually removed a few hundred of these entries and immediately noticed that the clean library step started speeding up again as I kept on removing these entries. I am fairly confident that this is causing the issue of slowing down the clean library step, at least in my case. I suspect that the XBMC logic finds these URLs and attempts to verify those files exist or something like that, thereby spending time during the clean library step.
These are plugin URLs and not files per se, so why are they being stored in the database?
Hope this is helpful and a developer can figure this out.
Thank you.
Akash