Monday, December 8, 2014

GUID vs INTEGER as data type of the Primary key in INTREXX

In this short post I would like to point out few differences between the use of Guid and Integer as a data type of  the primary key when creating a new data group.
  • Guid is treated as a string and Integer as it is.
  • Guid  has a larger range than Integer.
  • When creating a new row for example, to get the current primary key maybe in groovy you need newGuid() (for Guid) while you will need to make a query : select max(id) from dgroup (for Integer)
  That is just what I have in mind now, please feel free to drop a comment and share your thoughts on this with us.
 

No comments:

Post a Comment