alt Hacker News"one lightweight SELECT per millisecond"
This reminds me of the teenager who told her dad that she was just a tiny little bit pregnant.
Replies
sroussey • yesterday at 9:14 PM
Thing of the battery!
(read that in the way of "think of the children!")
"one lightweight SELECT per millisecond"
This reminds me of the teenager who told her dad that she was just a tiny little bit pregnant.
Thing of the battery!
(read that in the way of "think of the children!")
One cannot be a little bit pregnant. But a DB can be only a little bit in the RAM, and specifically in the page cache. SQLite can act exactly like that, and it's damn fast as long as it does not need to durably write a transaction. Polling once a millisecond could spend a few microseconds.
I wonder if using a tiny Redis instance, or even something like LevelDB would be even more efficient.