3 ms·
Maybe you are doing some sort of cursor for pagination or whatever. You can use one ID and fetch the next 50 records. Then use the last ID in those 50 to fetch
by postalrat 4y ago
Maybe you are doing some sort of cursor for pagination or whatever. You can use one ID and fetch the next 50 records. Then use the last ID in those 50 to fetch the next 50, etc.
- endisneigh 4y agobut you can still do pagination with uuids, your rows can be sorted on any arbitrary criteria like created date or updated date.
- postalrat 4y agoDates might not be unique but I can see other possibilities that would be fine.
- vanviegen 4y agoBut that would be slow, even with an index, as compared to using a clustered primary key. Especially when your data doesn't fit in ram.
- endisneigh 4y agoSure, already mentioned UUID’s being slow. There are trade offs