GUID Vs Int data type as primary key

added by jalpesh
12/1/2010 2:34:41 AM

0 Kicks, 58 Views

Recently one of my friend ask me when I should go for GUID and When I should go for Int as primary key in table. So decided blog post for that. Here are advantages and disadvantage of the GUID and INT. INT Data Type: Advantages:Its required small space in terms of the storage it will only allocates 4 bytes to store data. Insert and update performance will be faster then the GUID. It will increase the performance of the application. Easy to index and Join will give best performance with the integer. E..