2 ms·
I like it. Question, did you consider using composite keys of shard_id and id to make up a single primary key? If so what were the pros/cons you found with that
by artilheiro 15y ago
I like it. Question, did you consider using composite keys of shard_id and id to make up a single primary key? If so what were the pros/cons you found with that approach?
btw, tambem sou brasileiro vivendo em san francisco (https://twitter.com/#!/artilheiro https://twitter.com/#!/artilheiro)
- mikeyk 15y agoWe considered the composite key, but we often have to store keys in other systems like Redis, where having a single 64-bit integer makes it more portable and stored compactly (Redis, for example, has an optimization when storing integer values vs string values in its lists). Valeu pelo comentário!