Thanks, very insightful!
On Thu, Nov 30, 2017 at 5:27 PM J Decker <d3c...@gmail.com> wrote:
> I would also like to make a note, that many criticisms are 'there's so many
> bytes to have to compare', however, because of the highly random nature of
> good UUIDs failure occurs quickly, usually within 4 bytes, which makes it
> almost as good as an integer (especialy for things like SQLite that are
> comparing numbers as strings anyway).... the only time the full thing is
> compared is on the row that exactly matches.
Aha so that's why the UUIDs are don't have the full time as the first part…
I was wondering why they did not use this easy "sort by creation date"
sqlite-users mailing list