Reply to thread

Message

<blockquote data-quote="MJGraf" data-source="post: 1029641" data-attributes="member: 17886">To have a comparison, I have done the test with the standard SQLCEDatabase first.I had to make a single code change to the SQLCEDatabase before. I changed [CODE]INITIAL_MAX_DATABASE_SIZE = 1024[/CODE]to[CODE]INITIAL_MAX_DATABASE_SIZE = 2048[/CODE]because my import results in a database &gt; 1 GB and if I don't change this, the test would cancel in the middle and I would have to restart the MP2 Server and then continue the test.SQLCEDatabase (MP2 Alpha 3 version):Import Test: 139:34Read Test 1Query Time: 616 ms, 608 ms (1224 ms)Read Time: 78758 ms, 77671 ms (156429 ms)Read Test 2Query Time: 96 ms, 102 ms (198 ms)Read Time: 1264 ms, 1313 ms (2577 ms)Read Test 3Query Time: 301 ms, 300 ms (601 ms)Read Time: 422 ms, 399 ms (821 ms)Read Test 4Query Time: 300 ms, 336 ms (636 ms)Read Time: 1942 ms, 547 ms (2825 ms)Now I'll do the same test with SQLiteDatabase v0.07. If it passes the test, I will publish the results, push the source to Git and upload the binaries to our new plugin repository <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></blockquote>

[QUOTE="MJGraf, post: 1029641, member: 17886"] To have a comparison, I have done the test with the standard SQLCEDatabase first. I had to make a single code change to the SQLCEDatabase before. I changed [CODE]INITIAL_MAX_DATABASE_SIZE = 1024 [/CODE] to [CODE]INITIAL_MAX_DATABASE_SIZE = 2048 [/CODE] because my import results in a database > 1 GB and if I don't change this, the test would cancel in the middle and I would have to restart the MP2 Server and then continue the test. [U][B]SQLCEDatabase (MP2 Alpha 3 version):[/B][/U] [U]Import Test[/U]: [B]139:34[/B] [U]Read Test 1[/U] Query Time: 616 ms, 608 ms (1224 ms) Read Time: 78758 ms, 77671 ms (156429 ms) [U]Read Test 2[/U] Query Time: 96 ms, 102 ms (198 ms) Read Time: 1264 ms, 1313 ms (2577 ms) [U]Read Test 3[/U] Query Time: 301 ms, 300 ms (601 ms) Read Time: 422 ms, 399 ms (821 ms) [U]Read Test 4[/U] Query Time: 300 ms, 336 ms (636 ms) Read Time: 1942 ms, 547 ms (2825 ms) Now I'll do the same test with SQLiteDatabase v0.07. If it passes the test, I will publish the results, push the source to Git and upload the binaries to our new plugin repository :) [/QUOTE]

Verification