If you need to generate reproducible UUIDs from given names, you want a version 3 or version 5. The advantage of this version is that when you're debugging and looking at a long list of information matched with UUIDs, it's quicker to spot matches. If you just need to generate a UUID, this is probably what you want. Version 4: These are generated from random (or pseudo-random) numbers. The advantage of this version is that, while looking at a list of UUIDs generated by machines you trust, you can easily know whether many UUIDs got generated by the same machine, or infer some time relationship between them. If any of these things is sensitive in any way, don't use this. Version 1: This generates a unique ID based on a network card MAC address and current time. If you just need a unique ID, you want a version 1 or version 4. This will eliminate most of the I/O, which is the slow part of SQL.There are two different ways of generating a UUID. Your VM has 12GB, so change the setting to 8G. This change should help performance significantly. If you have more than 4GB, set that to about 70% of RAM.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |