News for hackers. Stuff that matters.

A comment on How long do GUIDs really need to be?. Parent comment

Re:How long do GUIDs really need to be? by jayvanguard on Friday October 31, 2014 @11:27PM (#8542096)
If you work with large amounts of data it hugely matters. 16 bytes times 1 billion records ends up being way more than 16GB of data, indexes, foreign keys, hot backup, etc. to manage and query.
[ Parent | on HN ]
Re:How long do GUIDs really need to be? by JoeAltmaier on Saturday November 01, 2014 @08:51AM (#8542865)
Even that is a small amount of memory. I have that much RAM on my computer. See, its an obsolete conversation, yet folks raised in an ecology of scarcity can't get past it.
[ Parent | on HN ]
Re:How long do GUIDs really need to be? by roganp on Saturday November 01, 2014 @11:03AM (#8543271)
It depends on what you are optimizing for. If you need to store your entire database in physical memory, then the difference between 16GB and 128MB is significant.
[ Parent | on HN ]