Comments on Best Guess Theory: NHibernate Tip #3 - ID's

another pro is u can allow external apps to creat...

2009-10-12T17:47:58.338-05:00

another pro is u can allow external apps to create their own ids too. for example we build a lot of RIAs using flex/air if that UI wants a new object it can create it's own id without the need for a service call and subsequent db hit, much more efficient when you have a network layer involved with a smart interface technology

Good points :) I view the guid vs int debate as a ...

2009-07-16T15:38:42.114-05:00

Good points :) I view the guid vs int debate as a pre-optimization debate. You really don't know how your application will perform until you have it up and running in a production environment. If Guids are, for some reason, causing performance issues, then you should be able to identify that problem, and if no other solution with guids (such as tuning or guid.comb) will work, you could go back to using ints.

Otherwise, I feel that the complexity of the model is increasing purely to compensate for database implementation details.

Huge improvements to the Guid index thrashing prob...

2009-07-16T15:21:07.877-05:00

Huge improvements to the Guid index thrashing problem were fixed in SQL 2005 and with DB tuning and guid.comb algo's page fragementation is really a thing of the past.