Query cache in SQLite

Question

Is there any mechanism to keep query results in order to reuse them the next time this query occurs? I'm not talking about SQLite's cache that stores pages retrieved from a database file. This is more about a query execution without using SQLite B-tree and Pager modules.

Answer 1

I don't think anything like this is built into SQLite. You might have to roll your own with memcached or an in-memory database unless you're using a framework that does this sort of thing.