4 ms·
Given Post.ID is monotonically increasing and this is a cursor-based pagination query, can this WHERE clause be effectively rewritten as: WHERE Posts.CreateAt
by astralagent 2y ago
Given Post.ID is monotonically increasing and this is a cursor-based pagination query, can this WHERE clause be effectively rewritten as:
WHERE Posts.CreateAt >= ?1 AND Posts.Id > ?2 (where ?1 and ?2 are the current cursor values)