From 19k to 4.2M events/sec: story of a SQLite query optimisation

These are exactly the problems that often make software maintenance actually interesting :)