Comment by yencabulator
24 days ago
Parent comment said "with a million or so rows". I looked up numbers for benchmarks with ~1M entries in the hashmap.
1M 64-bit integers is only 8MB, that's still a small keyspace.
24 days ago
Parent comment said "with a million or so rows". I looked up numbers for benchmarks with ~1M entries in the hashmap.
1M 64-bit integers is only 8MB, that's still a small keyspace.
Perhaps relevant is that probably only 25% of the IDs that get passed to the select actually have values and this is using one thread for the benchmark. It's too convoluted to share, but indeed when using the in memory database on a lower spec laptop currently I still get up to 20-30m reads per second, pretty close to the 40m on the big box.