2014-09-20, 10:52
Well, I have 5,000 movies and 20,000 episodes. So, this may just be the limit of RPi? Log file below:
http://xbmclogs.com/show.php?id=298332
http://xbmclogs.com/show.php?id=298332
(2014-09-20, 10:52)steve1977 Wrote: Well, I have 5,000 movies and 20,000 episodes. So, this may just be the limit of RPi? Log file below:
09:34:34 81.639458 T:3058721664 DEBUG: RunQuery took 5024 ms for 5138 items query: select * from movieview
09:34:36 83.567749 T:2907698256 DEBUG: RunQuery took 18072 ms for 15115 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
09:34:37 84.733887 T:2927858768 DEBUG: RunQuery took 15109 ms for 15115 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
09:33:57 44.425217 T:2890921040 DEBUG: Library Data Provider: script version 0.0.5 started
09:34:07 54.005543 T:2890921040 DEBUG: RunQuery took 9302 ms for 5125 items query: select * from movieview WHERE ((movieview.playCount IS NULL OR movieview.playCount = 0))
09:33:58 45.469742 T:2927858768 DEBUG: Library Data Provider: service version 0.0.5 started
09:34:10 57.547813 T:2927858768 DEBUG: RunQuery took 11655 ms for 5125 items query: select * from movieview WHERE ((movieview.playCount IS NULL OR movieview.playCount < 1))
09:34:37 84.733887 T:2927858768 DEBUG: RunQuery took 15109 ms for 15115 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
09:34:00 47.896164 T:2758104144 DEBUG: Library Data Provider: script version 0.0.5 started
09:34:02 49.519688 T:2758104144 DEBUG: RunQuery took 71 ms for 16 items query: select * from movieview WHERE (movieview.idFile IN (SELECT DISTINCT idFile FROM bookmark WHERE type = 1))
09:34:17 64.456177 T:2907698256 DEBUG: Library Data Provider: script version 0.0.5 started
09:34:36 83.567749 T:2907698256 DEBUG: RunQuery took 18072 ms for 15115 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
09:33:58 45.471077 T:2936247376 DEBUG: Skin Widgets: script version 0.0.29 started
09:34:11 58.327549 T:2936247376 DEBUG: RunQuery took 12454 ms for 5125 items query: select * from movieview WHERE ((movieview.playCount IS NULL OR movieview.playCount = 0))
09:34:26 73.408287 T:3058721664 DEBUG: Activating window ID: 10025
09:34:26 73.624168 T:3058721664 DEBUG: ------ Window Deinit (Home.xml) ------
09:34:27 74.778633 T:3058721664 DEBUG: ------ Window Init (MyVideoNav.xml) ------
09:34:27 74.778976 T:3058721664 INFO: Loading skin file: MyVideoNav.xml, load type: KEEP_IN_MEMORY
09:34:29 76.364243 T:3058721664 DEBUG: CGUIMediaWindow::GetDirectory (videodb://movies/titles/)
09:34:29 76.364693 T:3058721664 DEBUG: ParentPath = [videodb://movies/titles/]
09:34:34 81.639458 T:3058721664 DEBUG: RunQuery took 5024 ms for 5138 items query: select * from movieview
09:34:52 99.357559 T:3058721664 DEBUG: Saving fileitems [videodb://movies/titles/]
09:34:58 104.996925 T:3058721664 DEBUG: -- items: 5138, sort method: 0, ascending: true
06:02:07 26.946909 T:2890921040 DEBUG: CRecentlyAddedJob::UpdateMusic() - Running RecentlyAdded home screen update
...
06:02:30 49.511822 T:2890921040 DEBUG: RunQuery took 14998 ms for 10 items query: select * from episodeview ORDER BY dateAdded desc, idEpisode desc LIMIT 10
06:02:06 25.890249 T:2928051280 DEBUG: CPythonInvoker(0, /storage/.xbmc/addons/service.skin.widgets/default.py): start processing
...
06:02:56 75.784279 T:2928051280 DEBUG: RunQuery took 14779 ms for 15115 items query: select * from episodeview WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
06:02:16 35.072514 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/e/ecff65d3.jpg 360x540
06:02:35 54.673958 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/8/8d2e76b1.jpg 367x540
06:02:35 54.889355 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/a/a202e45a.jpg 367x540
06:02:36 55.100403 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/4/4a756af2.jpg 367x540
06:02:36 55.327229 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/9/971d13fc.jpg 367x540
06:02:36 55.528412 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/8/876be513.jpg 367x540
06:04:53 193.021896 T:2532430928 DEBUG: RunQuery took 134356 ms for 9 items query: SELECT * FROM seasonview WHERE seasonview.idShow = 18
06:04:54 193.214706 T:2532430928 DEBUG: RunQuery took 183 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie WHERE movielinktvshow.idShow = 18
...
06:04:58 197.224869 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/f/f2e11290.jpg 374x540
06:05:04 203.972260 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/0/07978e02.jpg 367x540
06:05:05 204.119705 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/3/3a988c2a.jpg 367x540
06:05:05 204.285675 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/9/971d13fc.jpg 367x540
06:05:05 204.443878 T:2532430928 DEBUG: DecodeJpegToTexture: decoded special://masterprofile/Thumbnails/7/77d17113.jpg 367x540
06:06:25 284.705872 T:2532430928 DEBUG: RunQuery took 73409 ms for 10 items query: SELECT * FROM seasonview WHERE seasonview.idShow = 27
06:06:25 284.873627 T:2532430928 DEBUG: RunQuery took 157 ms for 0 items query: select * from movieview join movielinktvshow on movielinktvshow.idMovie=movieview.idMovie WHERE movielinktvshow.idShow = 27
(2014-09-21, 09:47)Milhouse Wrote: which suggests the queries took over 134 seconds and 73 seconds to return the 9 season rows and 10 season rows respectively for two different tvshows - that's just bonkers.
(2014-09-21, 10:11)steve1977 Wrote: Any more thoughts with this additional context?
(2014-09-21, 10:11)steve1977 Wrote: I will try the gpu thing later today. Also thinking whether I should try mysql, but shouldn't this make things even worse as all my posters would then no longer be locally scored?MySQL has no impact on thumbnails, as these remain local in Textures13.db and the Thumbnails folder.
(2014-09-21, 10:11)steve1977 Wrote: Also, it wouldn't be too easy for me to do. I have a headless server (which would be perfect to host the mysql database), but unfortunately XBMC can still not run headless.What has XBMC got to do with running MySQL on your headless server? You don't need to run XBMC on the same server as MySQL - just configure your Pi to connect to the MySQL server.