Since MemSQL doesn’t support the UUID data type, what data type is best suited for UUID values?
I guess either BINARY(16) or VARBINARY(32)
Just like CockroachDB and Cloud Spanner, MemSQL will benefit by a random UUID rather than a optimised COMB version, right?
The image below shows benchmark for a single-node database. Apperantly, binary is only best for smaller data sets, so this makes me think a pure UUID version 4 stored in a VARBINARY(32) column is the best choice for many MemSQL use cases.