OpenELEC Testbuilds for RaspberryPi Part 2
I've uploaded a new build to help test some experimental database optimisations that are being discussed in this thread.

I've run some initial tests and the performance improvement for JSON database updates is huge. To give an example, when updating imdb votes and ratings on three movies:

Code:
.         Argo      K-F Panda 2     Avatar
Before: 32.069271      5.011988   22.674556
After:   0.256215      0.670386    0.146922

All times are in seconds.

Performance improvements should be expected anywhere a JSON database update occurs, either in an addon (eg. Artwork Downloader) or a script (texturecache,py).

Since these are experimental database changes I'm not including the changes in my normal builds but due to the significant improvement in performance I wanted to make a build available for anyone willing to help test, albeit at your own risk (take a backup of your MySQL/SQLite MyVideos* databases etc.)

The build can be downloaded here: #0217xp. It's basically #0217c plus the patches discussed in the above thread.

If/when the changes are proven to be safe/reliable/stable, and assuming there is a high probability of the changes being accepted into XBMC master, I'll include them in future "regular" builds. Issues/problems should be posted in the above linked thread.

Edit: Updated the experimental build to include crash-fix patch also added to #0217c
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.


Messages In This Thread
RE: OpenELEC Testbuilds for RaspberryPi Part 2 - by Milhouse - 2014-02-18, 01:57
AW: RE: - by DieterLumpen - 2013-07-29, 20:50
include guires switch? - by hpbaxxter - 2013-08-01, 21:46
RE: dual audio?? - by pootler - 2013-08-03, 17:13
Help, watch 3D Film on Non 3D TV - by unix72 - 2013-08-09, 12:39
Remote Controllers - by tfft - 2013-08-14, 09:11
rbej repeatable crash - by RichG - 2013-08-19, 12:43
New Tester - by theneverstill - 2013-10-03, 17:16