Posts: 7,135
Joined: Oct 2012
un1versal
Out of Memory (1939–2016)
Posts: 7,135
(2013-03-29, 21:13)MilhouseVH Wrote: It should certainly be deleting both the database row and the corresponding cached file - you can confirm this by enabling the logfile option (logfile = filename) and then looking to see if any SQL deletions took place. Though I'm not sure how sqlite3 manages its database size as rows are removed - maybe it never shrinks the database (potentially expensive and counter productive) and holds on to the now free space to be re-used in the future? You can get a row count by running the x option and piping the results through "wc -l", or use the "f" option - there's a rowcount summary at the end, along with the amount of disk space used by the corresponding files.
Sure will try next time.
(2013-03-29, 21:13)MilhouseVH Wrote: Again thanks. Though not sure what other switches to add right now, I'm fresh out of ideas... currently just tweaking the code and hoping to get to the bottom of this Pi killer issue. If you've got any suggestions for the future, fire away!
Anything that can benefit from a multithread could really really be added this, idk the script or scripting or any coding to make educated guesses, but If thers any Im sure you will know what to do. Your doing pretty well so far!.
(2013-03-29, 21:13)MilhouseVH Wrote: Not sure how long it will last - I only started it as a way to learn a new language, and to more easily extract rows from sqlite3 database - and now look at it...
Yea, things tend to get out of hand but as long as its helping and doing some job, its always a good idea. I started posting to help others and now am doing the odd xbmc wiki imrpovements/additions and am trying to get XWMM a push to get more developers interested and the ones that already worked on it to continue improving it, but Im not a coder, and Any projects like that need developers so they dont struggle, and its struggling.
I'de love to have someone half as skilled as you join these side projects which help many users, though keeping them going is not so easy. Perhaps now you have your stuff on github I can mess with a couple of ideas I had for you and maybe others will join in.
btw if you ever feel like you can help XWMM come by and see whats its like so far @
https://github.com/slash2009/XWMM or
http://forum.xbmc.org/showthread.php?tid=60643
Will go mess your gitcode in a jiffy and make a PR and do something else documentation related.
uNi
[/quote]
Posts: 7,135
Joined: Oct 2012
un1versal
Out of Memory (1939–2016)
Posts: 7,135
OK done some damage in your repo tryng to improve a couple of things. Thansk for merging.
Now all those radials can be called from script if needed and all is easier and not so clutered for you deving and maybe nickr and his promise to help you.
We could use someone like you @XWMM if you ever feel that way inclined please send some json and js our way.
uNi
Posts: 7,135
Joined: Oct 2012
un1versal
Out of Memory (1939–2016)
Posts: 7,135
@
millhouse
If this addon is updating improving you can consider adding a version check/pull/ask/display changelog via script too when script is first run.
uNi
Posts: 17,855
Joined: Jan 2011
Reputation:
1,055
Milhouse
Retired Team-Kodi Member
Posts: 17,855
v0.3.5 on Github - hopefully the version check/update process works...
* Added stats timings to the c/C/nc summary.
Interesting exercise trying to calculate elapsed time across multiple threads. The download times in the table of results will be shown per artwork type (ie. fanart, poster etc.), however the total download time may (and often will) be less than the sum of the individual times as downloads will overlap when using multiple threads. The total download time should equal the sum of individual download times only when using a single thread, or when downloading only a single artwork type.
The "Download" time at the very end of the summary will normally exceed the sum of the individual times, as it will include thread management overhead (startup, shutdown etc.)
* Added additional JSON artwork queries for Genre and Addon when pruning the texture cache.
* Added property "prune.retain.types", which are comma delimited regex patterns that will be kept when pruning, eg. "prune.retain.types = ^http://www.wiziwig.tv/" to keep wiziwig.tv artwork (as used by SportsDevil addon).
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.