Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
Currently we run a SELECT * FROM table to do snapshot. This works fine for small tables, but we should adjust it to take advantage of PK/UK and fetch data in batches.
Description
Currently we run a
SELECT * FROM tableto do snapshot. This works fine for small tables, but we should adjust it to take advantage of PK/UK and fetch data in batches.Change in user-visible behavior
Requires documentation change