Sequential (comb) GUIDs for Oracle

Posted by Eyvind on Stack Overflow See other posts from Stack Overflow or by Eyvind
Published on 2010-04-07T11:00:45Z Indexed on 2010/04/07 11:03 UTC
Read the original article Hit count: 254

Filed under:
|
|
|
|

We are in the process of switching from the C# Guid.NewGuid() random-ish guid generator to the sequential guid algorithm suggested in this post. While this seems to work well for MS SQL Server, I am unsure about the implications for Oracle databases, in which we store guids in a raw(16) field. Does anyone have any insight as to whether this algorithm would be good for creating sequential guids for Oracle as well as for MS SQL Server, or if a different variant should be used.

Thanks!

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about Oracle