UUID() / GUID Storage and Indexing

UUID() / GUID Storage and Indexing

This is a discussion on UUID() / GUID Storage and Indexing within the MySQL forums, part of the Database Server Software category; --> It seems the most compact way to store a UUID is to do the following into a BINARY(16): UNHEX(REPLACE(UUID(), ...

		Unix Technical Forum > Database Server Software > MySQL
UUID() / GUID Storage and Indexing

#1 (permalink)

02-28-2008, 10:20 AM

murraybrad@gmail.com

Posts: n/a

UUID() / GUID Storage and Indexing

It seems the most compact way to store a UUID is to do the following
into a BINARY(16):

UNHEX(REPLACE(UUID(), '-', ''))

If this is the be the primary key, would it be better for index
fragmentation to do the following:

UNHEX(REVERSE(REPLACE(UUID(), '-', '')))

instead so that the inserts are at least in order?

« Importing from non-delineated text? | Merging the Structure (not just the contents) of several small tables into one large table »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 06:11 AM.