Reply to thread

Message

<blockquote data-quote="MJGraf" data-source="post: 1036193" data-attributes="member: 17886">So to have a starting point - these are the current results with the ReadTest protocol as explained above:locking_mode=Exclusive / Shared Cache / Page Size 4KB / Discarded the respective first resultReadTimes:ReadTest 1: 11810ms, 11966ms (23776ms)ReadTest 2: 230ms, 202ms (432ms)ReadTest 3: 6.1ms, 6.9ms (13.0ms)ReadTest 4: 46.7ms, 33.5ms (80.2ms)The fact that ReadTest 2 is now much quicker than in all the tests before is that in the previous test protocol I did a restart of MP2 Server between ReadTest 1 and ReadTest 2. ReadTest 1 is a VERY heavy query, which already brings a lot of data into the SQLite cache. ReadTest 2 can apparently take advantage of this data in the cache. When I restart MP2 Server between ReadTest 1 and ReadTest 2, the results of ReadTest 2 are back to about 10-12ms (when discarding the first test result). So this is explainable and reproducible and I'll take these results now as a new starting point.</blockquote>

[QUOTE="MJGraf, post: 1036193, member: 17886"] So to have a starting point - these are the current results with the ReadTest protocol as explained above: [B]locking_mode=Exclusive / Shared Cache / Page Size 4KB / Discarded the respective first result[/B] ReadTimes: ReadTest 1: 11810ms, 11966ms ([B]23776ms[/B]) ReadTest 2: 230ms, 202ms ([B]432ms[/B]) ReadTest 3: 6.1ms, 6.9ms ([B]13.0ms[/B]) ReadTest 4: 46.7ms, 33.5ms ([B]80.2ms[/B]) The fact that ReadTest 2 is now much quicker than in all the tests before is that in the previous test protocol I did a restart of MP2 Server between ReadTest 1 and ReadTest 2. ReadTest 1 is a VERY heavy query, which already brings a lot of data into the SQLite cache. ReadTest 2 can apparently take advantage of this data in the cache. When I restart MP2 Server between ReadTest 1 and ReadTest 2, the results of ReadTest 2 are back to about 10-12ms (when discarding the first test result). So this is explainable and reproducible and I'll take these results now as a new starting point. [/QUOTE]

Verification