Day 5 results: offset vs keyset pagination
Measured on: (machine, OS, Python version)
Output
Paste part 1, part 2, part 3 and the scoreboard here.
One sentence per prediction
- P1 (offset, first page):
- P2 (offset, deep page):
- P3 (keyset, deep page):
- P4 (deep offset / keyset):
The Part 2 number
Rows the database touched to walk the table: offset __, keyset __. In one line, why:
What the query planner showed
Offset deep: __ Keyset deep: __
Part 3: the correctness bug
What offset showed twice: __ What keyset showed twice: __