2011-04-03, 06:59
I will attempt to recreate Nfusion2011's issues tomorrow and report my findings.
sjw1 Wrote:With an attitude like nfusion's, you guys have the patience and manners of Saints...
nfusion2011 Wrote:When movies are "CLEANED" from the database after the source is removed, it is implied that your database is 100% empty, yet a whole bunch of junk data remains in the .db file as shown by the screenshots and the evidently large file, and the fact that it still takes 2minutes to clean a database that should be 100% empty!
kricker Wrote:So from reading over the thread multiple times, it appears there are 2 main issues being discussed. The video database and the thumbnails folder.
Issue 1 the Thumbnail folder.
Orphaned items in the thumbnail folder has been a known issue for some time and anyone is welcome to suggest how to better clean this folder. Thanks to Bradvido88 there is now a script to help with this. The hope is this will eventually be done from within XBMC itself preferably with the "clean library" function or when a source is removed.
kricker Wrote:Issue 2 the video Database file.Good to know!
The database itself is something that has been hacked and tweaked over the years. Even now it is undergoing a re-work for various improvements.
kricker Wrote:Part of Nfusion2011's issue is that the database doesn't get cleaned sufficiently when sources/files are removed. This is the item I have just tested. I tested using a nightly build from March 14th Git:0897223, as that is what I currently have loaded on my dev PC. I can retest with a vanilla 10.1 install if need be. I started with a fresh new empty video database file and no video sources of any kind. Here was my process:
View database file and confirmed it is empty of any data
Added a video source in XBMC and scraped the info for that source. (CSI-Crime Scene Investigation, Season 11 containing 18 episodes)
exit XBMC
Viewed database file to view the new data
run XBMC / remove source from XBMC and let it clean the library on removal (now there are 0 video sources)
exit XBMC
viewed database to see what data remains (list below)
run XBMC / settings/video/Library/ Clean Library
exit XBMC
viewed database to see what data now remains (list below)
Here are the results:
Source added and scraped.
Video database contains items in the following tables:
actors 31 itemsTexture database contains items in the following tables:
path 2 items
files 18 items
tvshow 1 item
actorlinktvshow 13 items
studiotvlinkshow 1 item
episode 18 items
tvshowlinkepisode 18 items
tvshowlinkpath 1 item
actorlinkepisode 11 items
directorlinkepisode 4 items
writerlinkepisode 5 items
genrelinktvshow 1 item
studio 1 item
streamdetails 37 items
genre 1 item
texture 86 items
Source removed and library auto cleaned upon removal.
Video database still contains items in the following tables:
actors 31 itemsTexture database contains items in the following tables:
path 3 items
files 18 items
writerlinkepisode 5 items
studio 1 item
genre 1 item
texture 86 items
Video Library clean command run from settings.
Video database still contains items in the following tables:
actors 5 itemsTexture database contains items in the following tables:
path 1 item
files 18 items
writerlinkepisode 5 items
texture 86 items
I have copies of the database as well as the thumbnails folder and textures database at each step; new, source added and scraped, source removed with auto clean, and clean library command run from settings. I can share these with anyone who would like to see them.
nfusion2011 Wrote:Brad's script comes nowhere close to cleaning the junk data, it does do a much better job that what XBMC does, but it still has a long way to go to clean.I've updated the script to clean out a lot more junk. Link is in my signature.