home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 2
Plugin Development
SQLiteDatabase Plugin for MP2
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="MJGraf" data-source="post: 1036425" data-attributes="member: 17886"><p>To have a comparison, I did a complete run of tests as per the changed test protocol above for v0.07 and v0.08 Beta 2. Results as follows:</p><p></p><p><u><strong><u><strong>SQLiteDatabase (v0.07):</strong></u></strong></u></p><p>Import Test: <strong>31:38</strong></p><p><u>Read Test 1</u></p><p>Read Time: 11984 ms, 11945 ms (<strong>23929 ms</strong>)</p><p><u><u><u>Read Test 2</u></u></u></p><p>Read Time: 188 ms, 190 ms (<strong>378 ms</strong>)</p><p><u><u><u>Read Test 3</u></u></u></p><p>Read Time: 6.4ms ms, 8.2 ms (<strong>14.6 ms</strong>)</p><p><u><u><u>Read Test 4</u></u></u></p><p>Read Time: 93.0 ms, 81.1 ms (<strong>174.1 ms</strong>)</p><p><u><strong></strong></u></p><p><u><strong>SQLiteDatabase (v0.08 Beta 2):</strong></u></p><p>Import Test: <strong>19:17</strong></p><p><u>Read Test 1</u></p><p>Read Time: 11193 ms, 10926 ms (<strong>22119 ms</strong>)</p><p><u>Read Test 2</u></p><p>Read Time: 201 ms, 196 ms (<strong>397 ms</strong>)</p><p><u>Read Test 3</u></p><p>Read Time: 5.9ms ms, 5.1 ms (<strong>11 ms</strong>)</p><p><u>Read Test 4</u></p><p>Read Time: 31.8 ms, 79.1 ms (<strong>110.9 ms</strong>)</p><p></p><p><u><strong>Comparison SQLiteDatabase (v0.07) vs. SQLiteDatabase (v0.08 Beta 2):</strong></u></p><p>Import Test: <strong>164%</strong></p><p><u>Read Test 1</u></p><p>Read Time:<strong> 108%</strong></p><p><u><u>Read Test 2</u></u></p><p>Read Time:<strong> 95%</strong></p><p><u><u>Read Test 3</u></u></p><p>Read Time:<strong> 133%</strong></p><p><u><u>Read Test 4</u></u></p><p>Read Time: <strong>157%</strong></p><p></p><p>This means, v0.08 Beta 2 is 1.64 times as fast as v0.07 on imports (i.e. writes).</p><p>For reads we have no significant changes for Read Test 1 and 2 (both below 10%), but significant improvements for ReadTests 3 and 4 (the ones where we actually read covers from the database).</p><p></p><p>Not really bad. But my suspicion is that it will become more and more difficult to achieve further such big improvements by tweaking the database. I think when v0.08 is out, it is really time to make SQLite compatible with SlimTV Native. Seems more important to me now than getting some percent of further speed improvements (and I finally want to use SlimTV Native <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin :D" loading="lazy" data-shortname=":D" /> ).</p></blockquote><p></p>
[QUOTE="MJGraf, post: 1036425, member: 17886"] To have a comparison, I did a complete run of tests as per the changed test protocol above for v0.07 and v0.08 Beta 2. Results as follows: [U][B][U][B]SQLiteDatabase (v0.07):[/B][/U][/B][/U] Import Test: [B]31:38[/B] [U]Read Test 1[/U] Read Time: 11984 ms, 11945 ms ([B]23929 ms[/B]) [U][U][U]Read Test 2[/U][/U][/U] Read Time: 188 ms, 190 ms ([B]378 ms[/B]) [U][U][U]Read Test 3[/U][/U][/U] Read Time: 6.4ms ms, 8.2 ms ([B]14.6 ms[/B]) [U][U][U]Read Test 4[/U][/U][/U] Read Time: 93.0 ms, 81.1 ms ([B]174.1 ms[/B]) [U][B] SQLiteDatabase (v0.08 Beta 2):[/B][/U] Import Test: [B]19:17[/B] [U]Read Test 1[/U] Read Time: 11193 ms, 10926 ms ([B]22119 ms[/B]) [U]Read Test 2[/U] Read Time: 201 ms, 196 ms ([B]397 ms[/B]) [U]Read Test 3[/U] Read Time: 5.9ms ms, 5.1 ms ([B]11 ms[/B]) [U]Read Test 4[/U] Read Time: 31.8 ms, 79.1 ms ([B]110.9 ms[/B]) [U][B]Comparison SQLiteDatabase (v0.07) vs. SQLiteDatabase (v0.08 Beta 2):[/B][/U] Import Test: [B]164%[/B] [U]Read Test 1[/U] Read Time:[B] 108%[/B] [U][U]Read Test 2[/U][/U] Read Time:[B] 95%[/B] [U][U]Read Test 3[/U][/U] Read Time:[B] 133%[/B] [U][U]Read Test 4[/U][/U] Read Time: [B]157%[/B] This means, v0.08 Beta 2 is 1.64 times as fast as v0.07 on imports (i.e. writes). For reads we have no significant changes for Read Test 1 and 2 (both below 10%), but significant improvements for ReadTests 3 and 4 (the ones where we actually read covers from the database). Not really bad. But my suspicion is that it will become more and more difficult to achieve further such big improvements by tweaking the database. I think when v0.08 is out, it is really time to make SQLite compatible with SlimTV Native. Seems more important to me now than getting some percent of further speed improvements (and I finally want to use SlimTV Native :D ). [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Plugin Development
SQLiteDatabase Plugin for MP2
Contact us
RSS
Top
Bottom
