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: 1029668" data-attributes="member: 17886"><p>And now hold your breath... I just did these tests twice, because I couldn't believe it, but the difference between the two tests was < 5%. So here are the results:</p><p></p><p><u><strong>SQLiteDatabase (v0.07):</strong></u></p><p><u>Import Test: <strong>31:38</strong></u></p><p><u>Read Test 1</u></p><p>Query Time: 349 ms, 313 ms (<strong>662 ms</strong>)</p><p>Read Time: 12457 ms, 12159 ms (<strong>24616 ms</strong>)</p><p><u>Read Test 2</u></p><p>Query Time: 198 ms, 219 ms (<strong>417 ms</strong>)</p><p>Read Time: 245 ms, 239 ms (<strong>484 ms</strong>)</p><p><u>Read Test 3</u></p><p>Query Time: 0 ms, 3 ms (<strong>3 ms</strong>) [Note: First test run seems to be below the accuracy of our SQLDebug.Log entries]</p><p>Read Time: 20 ms, 19 ms (<strong>39 ms</strong>)</p><p><u>Read Test 4</u></p><p>Query Time: 18 ms, 16 ms (<strong>34 ms</strong>)</p><p>Read Time: 224 ms, 116 ms (<strong>340 ms</strong>)</p><p></p><p><u><strong>Comparison SQLCEDatabase (MP2 Alpha 3 version) vs. SQLiteDatabase (v0.07):</strong></u></p><p><u>Import Test: <strong>441%</strong></u></p><p><u>Read Test 1</u></p><p>Query Time: <strong>185%</strong></p><p>Read Time: <strong>635%</strong></p><p><u>Read Test 2</u></p><p>Query Time: <strong>47%</strong></p><p>Read Time: <strong>532%</strong></p><p><u>Read Test 3</u></p><p>Query Time: <strong>20033%</strong></p><p>Read Time: <strong>2105%</strong></p><p><u>Read Test 4</u></p><p>Query Time: <strong>1870%</strong></p><p>Read Time: <strong>830%</strong></p><p></p><p>SQLiteDatabase is nearly <strong>4,5x as fast</strong> as SQLCEDatabase in writing. It is <strong>between 5x and 21x as fast</strong> in reading and in general - with one exception - between <strong>1,8x and 200x as fast</strong> in executing SQL read queries. Why executing the read queries for Read Test 2 takes 2x longer is not clear yet. But since the Read Time of the same test is again more than 5x faster, I would suspect that SQLiteDatabase already reads something into RAM when the query is executed.</p><p></p><p>Not that bad, is it? <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: 1029668, member: 17886"] And now hold your breath... I just did these tests twice, because I couldn't believe it, but the difference between the two tests was < 5%. So here are the results: [U][B]SQLiteDatabase (v0.07):[/B] Import Test: [B]31:38[/B] Read Test 1[/U] Query Time: 349 ms, 313 ms ([B]662 ms[/B]) Read Time: 12457 ms, 12159 ms ([B]24616 ms[/B]) [U]Read Test 2[/U] Query Time: 198 ms, 219 ms ([B]417 ms[/B]) Read Time: 245 ms, 239 ms ([B]484 ms[/B]) [U]Read Test 3[/U] Query Time: 0 ms, 3 ms ([B]3 ms[/B]) [Note: First test run seems to be below the accuracy of our SQLDebug.Log entries] Read Time: 20 ms, 19 ms ([B]39 ms[/B]) [U]Read Test 4[/U] Query Time: 18 ms, 16 ms ([B]34 ms[/B]) Read Time: 224 ms, 116 ms ([B]340 ms[/B]) [U][B]Comparison SQLCEDatabase (MP2 Alpha 3 version) vs. SQLiteDatabase (v0.07):[/B] Import Test: [B]441%[/B] Read Test 1[/U] Query Time: [B]185%[/B] Read Time: [B]635%[/B] [U]Read Test 2[/U] Query Time: [B]47%[/B] Read Time: [B]532%[/B] [U]Read Test 3[/U] Query Time: [B]20033%[/B] Read Time: [B]2105%[/B] [U]Read Test 4[/U] Query Time: [B]1870%[/B] Read Time: [B]830%[/B] SQLiteDatabase is nearly [B]4,5x as fast[/B] as SQLCEDatabase in writing. It is [B]between 5x and 21x as fast[/B] in reading and in general - with one exception - between [B]1,8x and 200x as fast[/B] in executing SQL read queries. Why executing the read queries for Read Test 2 takes 2x longer is not clear yet. But since the Read Time of the same test is again more than 5x faster, I would suspect that SQLiteDatabase already reads something into RAM when the query is executed. Not that bad, is it? :D [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Plugin Development
SQLiteDatabase Plugin for MP2
Contact us
RSS
Top
Bottom
