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" shortcut… _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
