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 do a full index scan to get the exact number of rows during MySQL snapshot. This is a costly operation for big tables. We should find a way to not require it.
Description
Currently we do a full index scan to get the exact number of rows during MySQL snapshot. This is a costly operation for big tables. We should find a way to not require it.
Change in user-visible behavior
Requires documentation change