Follow up the issue #246. The current implementation of email watchers listing relies on offset-based pagination, which can lead to consistency issues as the dataset grows or when concurrent changes occur (e.g., new watchers being added or removed during pagination). Check the comment #246 (comment) for more detail
This ticket proposes replacing the offset-based pagination with seek-based pagination (also known as keyset pagination), which avoids issues related to record shifting during navigation.
Follow up the issue #246. The current implementation of email watchers listing relies on offset-based pagination, which can lead to consistency issues as the dataset grows or when concurrent changes occur (e.g., new watchers being added or removed during pagination). Check the comment #246 (comment) for more detail
This ticket proposes replacing the offset-based pagination with seek-based pagination (also known as keyset pagination), which avoids issues related to record shifting during navigation.