GUID OR INT ID

Question

User2041008840 posted

Hello, 
What should I use as auto-increment Int ID or UUID/GUID. 
I usually use Int ID. But which one is better as performance basis and Security basic or as future aspect on web application.
I am doing a project of asp.net core webapi. 

I know that id is much smaller in size than guid but what will be the best.

I seen Asp.net Identity uses Unique ID generator in ID column while creating user 

 

Answer 1

User475983607 posted

Prathamesh Shende

What should I use as auto-increment Int ID or UUID/GUID. 

Auto increment only works for an numeric type like an INT.

Prathamesh Shende

I usually use Int ID. But which one is better as performance basis and Security basic or as future aspect on web application.  I am doing a project of asp.net core webapi. 

There are pros and cons that a simple google search will discover. What are your performance and security requirement?   A GUID can be generated in the web application or DB.  Auto increment Ids are typically generated in the DB.