> On Jun 10, 2017, at 6:58 AM, Daniel Anderson <woni...@gmail.com> wrote: > > the article was integers (4 bytes) vs guid as a primary key, which as > string takes 36 bytes. so he was right in saying that string guid/uuid take > 9 time the space of simple integers.
Ah, that explains where he got 9x. I still think it’s an unfair comparison, given the inefficient encoding of the UUID (it should be a 16-byte blob.) And in any design problem that’s at sufficient scale that you’re even considering UUIDs, a 32-bit primary key isn’t going to be sufficient, so it should be 64-bit. Now we’re down to a 2x difference. > in general the article was quite good and allowed people to ponder about > their choices/beliefs. I would have been less critical, had the author identified that the subject domain is traditional RDBMSs. Instead the implication is that this is relevant to any database, which it isn’t. Anyway, arguing about databases is boring. It’s the weekend — I’m off to play guitar and go to parties ;-) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
