Subject | Re: Replication |
---|---|
Author | Frank Schlottmann-Gödde |
Post date | 2004-01-27T11:59:19Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
algorithm to generate guids.
There is an interesting article on this topic here:
http://www.informit.com/isapi/product_id~%7BE3D24CE5-F2A0-4B16-A39C-7AB17525F07C%7D/element_id~%7B1F208E62-0E29-4604-BF96-69BB0A1F9DAF%7D/st~%7BEA7C8D03-4995-402D-B085-06E000F897B8%7D/session_id~%7B3F003747-6775-4923-836D-D21FD3FAC8B6%7D/content/articlex.asp
Note that for use as a primary key for Firebird or Interbase you
should reverse the guids (especially if they are created on systems
other than Win 2000 and maybe above). This speeds up the index
creation significantly.
Frank
wrote:
> > Where can I find info about this? How do GUIDs work? Do they need anDepends on the OS, Windows 2000 and above apparently use a new
> > internet connection? Are they based on the current time?
> > If so, what is the time is not synchronized between the different
> > machines?
> >
> > Thanks!
> >
> > Jonathan Neve.
>
> GUIDs are spawned from a network card which is uniquely identified.
algorithm to generate guids.
There is an interesting article on this topic here:
http://www.informit.com/isapi/product_id~%7BE3D24CE5-F2A0-4B16-A39C-7AB17525F07C%7D/element_id~%7B1F208E62-0E29-4604-BF96-69BB0A1F9DAF%7D/st~%7BEA7C8D03-4995-402D-B085-06E000F897B8%7D/session_id~%7B3F003747-6775-4923-836D-D21FD3FAC8B6%7D/content/articlex.asp
Note that for use as a primary key for Firebird or Interbase you
should reverse the guids (especially if they are created on systems
other than Win 2000 and maybe above). This speeds up the index
creation significantly.
Frank