Posted on:July 30, 2022
Pros of GUID
-  You can generate IDs client side or anywhere else
-  Unique across every table, database and server
-  Allows easy distribution of databases across multiple servers
- They can contain extra information, such as the creation timestamp.
Cons of GUID
-  Being 16 bytes in size, it’s 4x larger than a 4 byte autoincrement ID.
-  Cumbersome to debug
-  Very inefficient to index
-  Not all languages and environments directly support GUIDs (but most of them do)