4 ms·

I'm a bit bummed out that in memory didn't increase performance, any idea why?

• Khoth 3y ago
  Sounds like they were testing it with a small enough amount of data that the disk version could just work from cache and didn't actually have to go to the disk
• joseferben 3y ago
  I've got a hunch that the data was too small to make a difference: https://stackoverflow.com/a/764743 https://stackoverflow.com/a/764743
• justinclift 3y ago
  A rough guess without knowing any better, would be that their SQLite configuration isn't flushing to disk after every write or similar. Maybe they ran their entire benchmark in a single transaction or something?
• globular-toast 3y ago
  The "on-disk" test was really in-memory too, thanks to various layers of caching etc.