Hi/Lo is so appealing to me because it is human readable. However, Guid.Comb is still very appealing in scenarios where Hi/Lo will not work.
Tuna, Are you implying that I can use Guid.Comb for app inserts and NEWSEQUENTIALID() for SSIS/ETL inserts and still reap the performance benefits of sequential guids (no index fragmentation)? To put it another way - will a guid.Comb identity generated on an app server play nice with NEWSEQUENTIALID() on the database server which is on another physical server. On Mar 21, 11:03 am, Tuna Toksoz <[email protected]> wrote: > Wouldn't Guid.Comb work for your case? > > Tuna Toksöz > Eternal sunshine of the open source mind. > > http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike > > On Sat, Mar 21, 2009 at 6:02 PM, Daniel Auger <[email protected]>wrote: > > > > > HiLo seems really slick. However as Tommaso pointed out a serious con > > may be integration and ETL scenarios. Would it be true to say that > > HiLo would not work if your entity tables can be inserted into both by > > your application and a nightly SSIS package? Are there any > > workarounds? > > > On Mar 19, 11:01 am, Tommaso Caldarola <[email protected]> wrote: > > > Use HiLo > > > > - pros: debug, diagnostic > > > - cons: integration, ETL > > > > tommaso > > > > On 19 Mar, 16:09, Will Shaver <[email protected]> wrote: > > > > > I'm using scope_identity while I develop because it is MUCH easier to > > > > debug. I plan to switch it over to GUIDs before deployment. (After > > > > running my tests and making sure nothing breaks. Not doing any ORDER > > > > BY ID calls, so everything should be fine. > > > > > On Thu, Mar 19, 2009 at 7:50 AM, James Gregory < > > [email protected]> wrote: > > > > > I guess it's about time that I stopped using identities then :) Don't > > hit > > > > > me, I'm sorry. > > > > > On Thu, Mar 19, 2009 at 2:44 PM, Fabio Maulo <[email protected]> > > wrote: > > > > > >> ah... thanks to Raffaele Rialdi to post the link in his blog > > >http://blogs.ugidotnet.org/raffaele/archive/2008/12/22/un-motivo-in-p... > > > > > >> 2009/3/19 Tuna Toksoz <[email protected]> > > > > > >>> I will try once more :) > > > > > >>> Tuna Toksöz > > > > >>> Eternal sunshine of the open source mind. > > > > > >>>http://devlicio.us/blogs/tuna_toksoz > > > > >>>http://tunatoksoz.com > > > > >>>http://twitter.com/tehlike > > > > > >>> On Thu, Mar 19, 2009 at 4:38 PM, Fabio Maulo <[email protected] > > > > > >>> wrote: > > > > > >>>> 2009/3/19 Ayende Rahien <[email protected]> > > > > > >>>>> Should we add this to to docs? > > > > >>>>> Suggesting that while we support identity fully, we are not > > > > >>>>> recommending it? > > > > > >>>> LOL, ahahahahahahahahaha. LOL > > > > >>>> Sure... but you know.... we are working in this matter for > > looooong time > > > > >>>> without a result. > > > > >>>> The masochists exist, we can't convert everybody. > > > > > >>>> -- > > > > >>>> Fabio Maulo > > > > > >> -- > > > > >> Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
