4 ms·
It would seem sequential keys for database performance is more than a 'specific' need.
by xcrunner529 3y ago
It would seem sequential keys for database performance is more than a 'specific' need.
- ricardobeat 3y agoThose are not helpful for database performance in a general sense. Last product I worked on used v4 uuids as primary keys without any issues - single master database, sorting by creation time only used in admin panels. You can index on created_at if needed. The IDs being sortable would be a non-feature. Generating sortable IDs in very high volume, in a distributed architecture, is a problem very specific to systems like social networks, metrics collection etc. You won’t need that for your average e-commerce app or machine parts database.