MySQL数据库表的主键到底是用GUID好,还是INT好?
待补充
?
?两遍对比的文章:
http://krow.livejournal.com/497839.html
?
?http://www.mysqlperformanceblog.com/2007/03/13/to-uuid-or-not-to-uuid/
?
CREATE TABLE Test_Guid
(
Guid varchar(50) not null,
TestId int not null,
TestText ntext not null,
TestDateTime datetime default getdate(),
CONSTRAINT PK_Guid PRIMARY KEY (Guid)
)
应该改成这样吧:
CREATE TABLE Test_Guid
(
Guid uniqueidentifier not null,
TestId int not null,
TestText ntext not null,
TestDateTime datetime default getdate(),
CONSTRAINT PK_Guid PRIMARY KEY (Guid)
)
?