S.Isaac Dealey wrote: >> >> That's a good idea, except that UUIDs take more >> space and are slower to index when compared to >> integers. However, that's only a problem if you >> are dealing with large amounts of data. > > It only starts to become an issue with tens of millions of records, at > which point you have bigger issues than indexing a 32 character string > instead of an integer.
Offially a UUID is a 128-bit unsigned integer (RFC 4122). If your database is smart it will only take 16 bytes of storage. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236967 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
