Re: Extending uniqid() or not?
Yasuo Ohgaki wrote:
Yasuo ... Stas has pointed out that there are other options, but it's probably worth flagging an important point here in relation to unique identifiers and databases. UUID can be something of a millstone, and may not actually be necessary. Certainly storing a non-optimised UUID can create a bottleneck if it's structure makes indexing it 'distorted'. Certainly on Firebird the UUID functions can be selected to produce an better spread of keys when producing the indexes. However it is still not 'ideal' at creating a unique ID anyway, and simply using a much more efficient 'SEQUENCE' ( in Firebird these are caller generators and have recently been updated to BIGINT hence my interest in the under the hood 64bit stuff elsewhere! ) and combine that with a machine related unique id if necessary. While MAC address should be unique it can be overridden and often is to get around MAC related licence limits ... not that we would condone that.
There is a nice paper on this on the Firebird site, but I can't locate it at the moment. Don't you just love 'google' as a site search tool :(
--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
Thread (29 messages)