Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Ask HN: GUID, int, or both for primary key?.
Many DBs order the table by PK. If the GUID value moves backward, that's a slow insert into the middle instead of a fast append to the end.
https://dba.stackexchange.com/a/17212
There are no comments on this comment yet.
Many DBs order the table by PK. If the GUID value moves backward, that's a slow insert into the middle instead of a fast append to the end.
https://dba.stackexchange.com/a/17212