主键设置（Primary key settings）.docVIP

主键设置（Primary key settings） You may want to add a O (old) to the old data primary key to indicate that this is the old data, then the automatically growing digital type is also facing a challenge. Third: Max plus 1 The automatic numbering of those problems, so some of my friends used to generate their own, is the same number, only to grow automatically removed, used in the Insert, read the Max value plus one, this method can avoid the problem of automatic numbering, but there is a problem of efficiency, if the record is large enough. Then (Max) will also affect the efficiency; more serious is the concurrency problem, if there are two people read the same Max, plus one after insertion of the ID value will repeat, this is a lesson. Fourth: homemade plus one Considering the efficiency of Max plus one, some people use the add one, that is, to build a special table, the field is: table name, the current sequence value. In this table to insert value, first from this table to find the corresponding table after the maximum plus one, insert, one may find that there may be concurrent processing, the concurrent processing, we can use the lock thread to avoid, in this value is generated when the first Lock, the the value of unLock, and then out, so there is no two generation at the same time. This is much faster than the Max plus one. There is also a problem in integration with other systems, from the generation method in the system, to ensure the maximum value and the trouble of homemade consistent import table, and digital are import problems of the above mentioned O old data. As a result, you can set the primary key into character type in add one. Character type home add I recommend, and should be a character type primary key can deal with many of our unexpected situation. Fifth: GUID primary key At present, a good primary key is the use of GUID, of course I recommend or primary key character, but the value generated by the GUID, GUID can be generated automatically, can also