[sqlite] Testing sqlite wal performance OS X memory/disk

Hello ! Comparing the three systems tested: raspibian raspberry pi3: 53us linux celeron: 12us os x i5: 7.7us One thing that I was expecting is that when using all core/threads (and because basically all data in in memory/cache) that I'll have around 100% cpu load but I don't, so ther

[sqlite] Testing sqlite wal performance OS X memory/disk

Hello ! Here is the same tests on a raspberry pi3: raspberry pi3 memory database 1 thread: Update rate: total=214229, last_total=194712, rate=19517, avg1=19517, avg2=19475 Update busy rate: total=0, last_total=0, rate=0, avg1=0, avg2=0 Update failed rate: total=0, last_total=0, rate=0, avg

[sqlite] Testing sqlite wal performance OS X memory/disk

On 25 Mar 2016, at 6:21pm, Domingo Alvarez Duarte wrote: > One thing that I was expecting is that when using all core/threads (and > because basically all data in in memory/cache) that I'll have around 100% cpu > load but I don't, so there is something that is preventing usage of all > system re

[sqlite] Testing sqlite wal performance OS X memory/disk

Hello ! I modified a bit the program to somehow test sqlite/system performance at https://gist.github.com/mingodad/79225c88f8dce0f174f5 , now we can also specify a memory database and doing so on a mac mini i5 2/4 cores surprisingly memory database when shared with 4 threads is slower than di