Cache parsed queries #91

New issue

Open

opened 2020-08-06 16:54:45 +00:00 by gburd · 0 comments

gburd commented

2020-08-06 16:54:45 +00:00

(Migrated from github.com)

For a given open database, and a given schema, we only need to process a query once — we can get all the way through to SQL and projections, and re-run multiple times.

Note that this is only true if the bindings in the query don't affect the analysis. I believe we're currently safe in this regard.

We can invalidate the cache when the schema changes.

Caching should be opt-in via an optional argument to <q.

For a given open database, and a given schema, we only need to process a query once — we can get all the way through to SQL and projections, and re-run multiple times. Note that this is only true if the bindings in the query don't affect the analysis. I believe we're currently safe in this regard. We can invalidate the cache when the schema changes. Caching should be opt-in via an optional argument to `<q`.