Slide 36
Slide 36 text
KeySet Pagination
The Seek Method
s-aaa
Surname Name Age
n-aaa 20
s-aaa n-bbb 10
s-aaa n-ccc 30
s-aaa n-ddd 5
s-bbb n-aaa 5
s-bbb n-bbb 8
s-bbb n-ccc 30
s-bbb n-ddd 25
s-ccc n-aaa 30
s-ccc n-bbb 40
s-ccc n-ccc 12
Age
40
31
30
30
30
25
20
10
8
5
5
Name
n-ccc
n-aaa
n-ccc
n-ccc
n-bbb
n-ddd
n-aaa
n-bbb
n-bbb
n-ddd
n-aaa
s-ccc
Surname
s-ccc
s-bbb
s-aaa
s-ccc
s-bbb
s-aaa
s-aaa
s-bbb
s-aaa
s-bbb
SELECT age, name, surname
FROM person
ORDER BY
age DESC,
name DESC,
surname DESC
SELECT age, name, surname FROM person
ORDER BY age DESC, name DESC, surname DESC
LIMIT 4;
Age
40
31
30
30
Name
n-ccc
n-aaa
n-ccc
n-ccc
s-ccc
Surname
s-ccc
s-bbb
s-aaa
Age Name Surname
30
25
20
10
n-bbb
n-ddd
n-aaa
n-bbb
s-ccc
s-bbb
s-aaa
s-aaa
Age Name Surname
8
5
5
n-bbb
n-ddd
n-aaa
s-bbb
s-aaa
s-bbb
SELECT age, name, surname FROM person
WHERE (age, name, surname) < (30, 'n-ccc', 's-aaa')
ORDER BY age DESC, name DESC, surname DESC
LIMIT 4;
SELECT age, name, surname FROM person
WHERE (age, name, surname) < (10, 'n-bbb', 's-aaa')
ORDER BY age DESC, name DESC, surname DESC
LIMIT 4;