Reply to thread

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 result

ReadTimes:

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.


Top Bottom