3 ms·
tl;dr Use UUIDv4 and get on with your day.
by paulddraper 5y ago
tl;dr
Use UUIDv4 and get on with your day.
- ygra 5y agoWell, not if you need database primary keys with sensible index locality. Which is what this draft is about.
- phkahler 5y agoAren't indexes sorted? I suppose using time as the MSBs means new batches are always appended (after sorting just the new ones).
- mianos 5y agoYes they are. But, consider the common query, for records based on an time index on the last day. This index will point to a bunch of primary keys and those, being random, will be spread across a much wider range of blocks. If the primary key was just the time, those items would be on the same or close blocks.