If I am using a hilo generator with nhibernate, what should the datatype for my id column be? int or bigint?
views:
81answers:
1
+1
Q:
What datatype should be used for the Id primary key columns using a hilo generator and sql server?
+2
A:
What are the data requirements? If you need more than 2 billion rows, including deletes/rollbacks then go bigint EDIT: I suppose you could start the identity at -2 billion and get double your pleasure
Scot Hauder
2010-03-11 00:46:59
otherwise, an int will suffice.
Will Marcouiller
2010-03-11 01:08:14