HiLo vs Identity?

Posted by Mendy on Stack Overflow See other posts from Stack Overflow or by Mendy
Published on 2010-03-15T18:49:31Z Indexed on 2010/03/22 2:31 UTC
Read the original article Hit count: 826

Filed under:
|
|

This is the same question as: http://stackoverflow.com/questions/803872/hilo-or-identity

Let's take the database of this site as an example.

Lets say that the site has the following tables:

  • Posts.
  • Votes.
  • Comments.

What is the best strategy to use for it:

Identity - which is more common.

OR

HiLo - which give best performance.

Edit: if HiLo is the best, how the structure of the DB would be?

© Stack Overflow or respective owner

Related posts about hilo

Related posts about nhibernate