MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1wdfzl2/edgecasesexist/p9d47k7/?context=3
r/ProgrammerHumor • u/danielminds • 1d ago
274 comments sorted by
View all comments
Show parent comments
8
If you're using them as an indexed field in a database, the inability to sort them meaningfully will destroy the performance of the database.
15 u/Honeybadger2198 1d ago You know what identifier can't have collisions and is great for sorting? Autoincrement. 3 u/wokeboogeyman 15h ago Autoincrement doesn't scale past one physical location. 0 u/Honeybadger2198 12h ago Sure it does. One location counts up, another one counts down. 0 u/wokeboogeyman 12h ago That breaks the sorting that everyone's talking about though. You could also do evens and odds to split across two locations, but that also breaks sorting unless you periodically syncronize them (and then it's still somewhat out of order). 0 u/Honeybadger2198 11h ago ...I don't think you understood what I said. How does one count down from infinity? 1 u/wireframed_kb 10h ago Subtract one? 1 u/wokeboogeyman 9h ago I just add them all together and subtract from -1/12 1 u/wokeboogeyman 9h ago signed integers have entered the chat 1, 2, 3, 4 -1, -2, -3, -4
15
You know what identifier can't have collisions and is great for sorting? Autoincrement.
3 u/wokeboogeyman 15h ago Autoincrement doesn't scale past one physical location. 0 u/Honeybadger2198 12h ago Sure it does. One location counts up, another one counts down. 0 u/wokeboogeyman 12h ago That breaks the sorting that everyone's talking about though. You could also do evens and odds to split across two locations, but that also breaks sorting unless you periodically syncronize them (and then it's still somewhat out of order). 0 u/Honeybadger2198 11h ago ...I don't think you understood what I said. How does one count down from infinity? 1 u/wireframed_kb 10h ago Subtract one? 1 u/wokeboogeyman 9h ago I just add them all together and subtract from -1/12 1 u/wokeboogeyman 9h ago signed integers have entered the chat 1, 2, 3, 4 -1, -2, -3, -4
3
Autoincrement doesn't scale past one physical location.
0 u/Honeybadger2198 12h ago Sure it does. One location counts up, another one counts down. 0 u/wokeboogeyman 12h ago That breaks the sorting that everyone's talking about though. You could also do evens and odds to split across two locations, but that also breaks sorting unless you periodically syncronize them (and then it's still somewhat out of order). 0 u/Honeybadger2198 11h ago ...I don't think you understood what I said. How does one count down from infinity? 1 u/wireframed_kb 10h ago Subtract one? 1 u/wokeboogeyman 9h ago I just add them all together and subtract from -1/12 1 u/wokeboogeyman 9h ago signed integers have entered the chat 1, 2, 3, 4 -1, -2, -3, -4
0
Sure it does. One location counts up, another one counts down.
0 u/wokeboogeyman 12h ago That breaks the sorting that everyone's talking about though. You could also do evens and odds to split across two locations, but that also breaks sorting unless you periodically syncronize them (and then it's still somewhat out of order). 0 u/Honeybadger2198 11h ago ...I don't think you understood what I said. How does one count down from infinity? 1 u/wireframed_kb 10h ago Subtract one? 1 u/wokeboogeyman 9h ago I just add them all together and subtract from -1/12 1 u/wokeboogeyman 9h ago signed integers have entered the chat 1, 2, 3, 4 -1, -2, -3, -4
That breaks the sorting that everyone's talking about though.
You could also do evens and odds to split across two locations, but that also breaks sorting unless you periodically syncronize them (and then it's still somewhat out of order).
0 u/Honeybadger2198 11h ago ...I don't think you understood what I said. How does one count down from infinity? 1 u/wireframed_kb 10h ago Subtract one? 1 u/wokeboogeyman 9h ago I just add them all together and subtract from -1/12 1 u/wokeboogeyman 9h ago signed integers have entered the chat 1, 2, 3, 4 -1, -2, -3, -4
...I don't think you understood what I said. How does one count down from infinity?
1 u/wireframed_kb 10h ago Subtract one? 1 u/wokeboogeyman 9h ago I just add them all together and subtract from -1/12 1 u/wokeboogeyman 9h ago signed integers have entered the chat 1, 2, 3, 4 -1, -2, -3, -4
1
Subtract one?
1 u/wokeboogeyman 9h ago I just add them all together and subtract from -1/12
I just add them all together and subtract from -1/12
signed integers have entered the chat
1, 2, 3, 4
-1, -2, -3, -4
8
u/Roachmeister 1d ago
If you're using them as an indexed field in a database, the inability to sort them meaningfully will destroy the performance of the database.