The one point I went looking for and didn't see is that UUID's make for very poo... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

braveo on June 10, 2017 | parent | context | favorite | on: Be Careful with UUID or GUID as Primary Keys

The one point I went looking for and didn't see is that UUID's make for very poor clustered indexes. SQL Server tried to mitigate this with the 'NEWSEQUENTIALID', but it essentially 'resets' when the server is rebooted.

If your data is small enough that it doesn't matter then fine, but in general UUID's are better as a surrogate key than as a primary key.

UK-AL on June 10, 2017 | [–]

Very few people generate the guids database side. They normally generate them before they even insert it into the database.

jrochkind1 on June 10, 2017 | [–]

Yes, that's in the OP, exactly what you said.

braveo on June 10, 2017 | [–]

It was, I meant I went looking for it in the article and didn't see it :)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact