Hey, I'm using uuid as PK for my users table and I...
# orm-helpk
Kenny Tran
09/24/2022, 8:37 AMHey, I'm using uuid as PK for my users table and I would like to use cursor based pagination. Is that possible with uuid or do I need to add another unique column that's incremental?
✅ 1
j
Jarupong
09/24/2022, 1:41 PMHi Kenny, I suggest you to use auto increment if you want cursor base pagiantion. UUID I can say that it's possible but it's will not be good in long term because it cannot identify as sequential values.
Jarupong
09/24/2022, 1:42 PMbecause cursor base you have orderBy your cursor field
Jarupong
09/24/2022, 1:43 PMbut you can create composite index like UUID with sequential values(eg. createdAt, updatedAt)
Jarupong
09/24/2022, 1:43 PMI hope my answer is help you
5 Views