I drink to that! 2017-06-10 14:26 GMT-04:00 Jens Alfke <j...@mooseyard.com>:
> > > 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 > -- Daniel *L'action accède à la perfection quand, bien que vivant, vous êtes déjà mort* *Bunan* _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
