3 ms·
What's wrong with non-integer primary keys?
by Phelinofist 3y ago
What's wrong with non-integer primary keys?
- takethisdownplz 3y agobesides performance for using something that is not often tested by devs working in performance, bad support for locale collating and open you for bugs such as indexing on email but allowing application to store both upper and lower case etc.
- evilspammer 3y agoI would expect they're referring to UUIDs or something
- tomnipotent 3y agoYou can pack fewer of them into a page, which means more disk IO for things like index scans.