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
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.
Member
75 Points
172 Posts
GUID OR INT ID
Apr 05, 2021 02:37 PM|Prathamesh Shende|LINK
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
All-Star
53711 Points
24031 Posts
Re: GUID OR INT ID
Apr 05, 2021 02:46 PM|mgebhard|LINK
Auto increment only works for an numeric type like an INT.
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.