Hi Ken - thanks for answering. :-) Thomas
On 22 Dec., 13:23, Ken Egozi <[email protected]> wrote: > 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/bloghttp://www.delver.comhttp://www.musicglue.comhttp://www.castleproject.orghttp://www.idcc.co.il- > הכנס הקהילתי הראשון למפתחי דוטנט - בואו בהמוניכם- Skjul tekst i > anførselstegn - > > - Vis tekst i anførselstegn - -- 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.
