3 ms·

You're still trading O(1) by O(N)... SQLite still has to read from the disk, it's still multiple orders of magnitude more expensive than a memory lookup.

• hinkley 4y ago
  On the one hand the individual reads will result in less blocking of write operations. On the other the read consistency behavior of the system changes by interlacing writes into the middle of your query.
• hgsgm 4y ago
  You can cache the database or part of it in memory.
  • drowsspa 4y ago
    Honestly, these workarounds to avoid doing a better architecture or to mask algorithmic complexity just come back around you to byte you.
    • ilyt 4y ago
      The key method here is not being in the project when the consequences arrive