Posted by Michael Fesser on 08/29/07 09:25

..oO(fjm67)

>Without getting into a Holy War, I have decided to use GUIDs as my PKs
>becuae there are limitations to INDENTITY datatypes and besides they
>are not very portable.

This just depends on the implementation. Instead of AUTO_INCREMENT using
a sequence to generate the ID before inserting the record could be
another option (MySQL doesn't support them natively like other DBMS, but
there are ways to emulate them).

The main problem with GUIDs as PKs is that they waste a lot of space for
nothing, even more if they're referenced as FKs.

Micha

[Back to original message]