GUID и PK

← →
Niki (2003-05-12 13:35) [0]

Добрый день, возник вопрос:
заметна ли разница в использовании GUID как PrimaryKey, по сравнению с типом integer, и в чем она выражается?
какие еще пакости можно встретить при работе с GUID?
Спасибо

← →
Niki (2003-05-12 16:00) [1]

Close topic. Found.

The uniqueidentifier data type has several disadvantages:

The values are long and obscure. This makes them difficult for users to type correctly, and more difficult for users to remember.

The values are random and cannot accept any patterns that may make them more meaningful to users.

There is no way to determine the sequence in which uniqueidentifier values were generated. They are not suited for existing applications that depend on incrementing key values serially.

At 16 bytes, the uniqueidentifier data type is relatively large compared to other data types such as 4-byte integers. This means indexes built using uniqueidentifier keys may be relatively slower than implementing the indexes using an int key.

Consider using the IDENTITY property when global uniqueness is not necessary, or when having a serially incrementing key is desirable.

← →
Zz_ (2003-05-12 16:04) [2]

http://www.sql.ru/forum/actualthread.aspx?bid=1&tid=24507

Самообслуживание?

GUID и PK Найти похожие ветки