Hacker News new | ask | show | jobs
by felooboolooomba 52 days ago
"one lightweight SELECT per millisecond"

This reminds me of the teenager who told her dad that she was just a tiny little bit pregnant.

2 comments

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.

With the file-watch APIs is that you don't need to poll at all - free is better than cheap.
Thing of the battery!

(read that in the way of "think of the children!")