SQLite Forum

SQLite turns 20
Login
That is because you forgot to constrain the timestamp of the memory, and a couple trillion years of events is a lot to search for a bit of joy.  You probably should also make sure you have an index on (joy, timestamp) unless you want a long non-productive table search ...