4 ms·
Readyset auto-parameterizes cached queries similar to a prepared statement. If you run the same query with different parameters, it will be routed to the cache.
by lukoktonos 3y ago
Readyset auto-parameterizes cached queries similar to a prepared statement. If you run the same query with different parameters, it will be routed to the cache. The first time a parameter set is queried, it will be a cache miss and trigger an "upquery" to populate the cache, after which that set of parameters will be served from the cache.
Different where clauses (sets of parameters) would map to different query-caches and currently need to be cached separately.
Aggregates supported by Readyset[1] will also be automatically maintained, but depending on the query, they may be handled by post-processing after retrieving results from a cache
[1] https://docs.readyset.io/reference/features/queries#aggregations https://docs.readyset.io/reference/features/queries#aggregat...