since the time part is the most significant part in the generated guid, it is guaranteed that an entry A that gets to the DB in a time later then entry B, will be placed after it in the index.
a contention will happen if more than one item is being created within the same millisecond (highly unlikely on non-super-high-traffic websites / super-loaded transactional systems etc.), and even then, the index fragmantation is only on the last page, most of the index is not influenced at all. off course - you'd want all of the machines generating the Guid.Comb to sync their clocks. On Tue, Dec 22, 2009 at 1:45 PM, Thomas Koch <[email protected]> wrote: > Hi - I have begun using the guid.comb id generator for my NH domain > objects using a SQL server 2005. > > When I read page 7 in: > http://www.informit.com/articles/article.aspx?p=25862&seqNum=7 > > Jimmy Nilsson mentions that the last six bytes is the current date and > time, and that you cannot determine the object creation order from the > primary key. This behaviour is consistent with what I am experiencing. > > So far so good. :-) > > What I am concerned about is the fragmentation of the index on the > primary key. How can this apparently random order prevent the index > from being ruined? > > Kind regards > Thomas > > -- > > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > > -- Ken Egozi. http://www.kenegozi.com/blog http://www.delver.com http://www.musicglue.com http://www.castleproject.org http://www.idcc.co.il - הכנס הקהילתי הראשון למפתחי דוטנט - בואו בהמוניכם -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
