4 ms·
Yep! And here's a mini guide I wrote to building a SQLite DB that queries in sub-millisecond time: https://gist.github.com/timmc/df5fbb6e069fb8c1c4e181a29930ac
by phyzome 7y ago
Yep! And here's a mini guide I wrote to building a SQLite DB that queries in sub-millisecond time:
https://gist.github.com/timmc/df5fbb6e069fb8c1c4e181a29930ace3 https://gist.github.com/timmc/df5fbb6e069fb8c1c4e181a29930ac...
I didn't bother with using binary keys, and just used hex, because I couldn't be arsed to do something more than `.mode csv` and `.import hashes.lst hashes` at the time, but it would be easy to write a tiny Python program to halve the space, as you say.