List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 29 2004 5:53am
Subject:Re: GUID storage
View as plain text  
In the last episode (Jun 28), Ray Kiddy said:
> Is it in the plans to have a 128 bit numeric column type for MySQL?
> If so, in what kind of time frame? If not, why not?

I don't know of any 32-bit compiler that provides a 128-bit integer
type, which means for most platforms mysql would have to require a
bignum library (openssl or libgmp) to support it in any meaningful
fashion, and it wouldn't be very fast.

> Character arrays are obviously, but they are probably not the best
> way to get optimal performance. Native support for a 128 bit number,
> usable as a UUID, would be better.

You're not doing math on those UUIDs in mysql, are you?  A CHAR(16)
BINARY field to store a raw UUID in sounds pretty optimal to me.

	Dan Nelson
GUID storageLarry Lowry12 May
  • Re: GUID storageMike Hillyer12 May
  • Re: GUID storageJeremy Zawodny12 May
    • Re: GUID storageUnknown Sender29 Jun
      • Re: GUID storageDan Nelson29 Jun
  • Re: GUID storageDan Nelson12 May
  • Re: GUID storageLarry Lowry12 May
    • Re: GUID storageDan Nelson13 May
    • Re: GUID storageSergei Golubchik13 May