Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
ahachete
on June 9, 2017
|
parent
|
context
|
favorite
| on:
Be Careful with UUID or GUID as Primary Keys
You should really read this:
https://www.slideshare.net/MarkusWinand/p2d2-pagination-done...
whateveracct
on June 9, 2017
[–]
Yep the Seek Method for pagination as suggested there would cause you to be sorting by UUID.
SELECT uuid FROM t where filterable_field > $whatever and uuid > $lastSeen limit $pageSize
with a covering index on (filterable_field, uuid)
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
