in reply to Re^2: Managing a graph with large number of nodes
in thread Managing a graph with large number of nodes
Well, in this case it seems that the whole schema will be just two tables
and that's about it.CREATE TABLE dbo.Users ( Id int not null identity(1,1) primary key, Code varchar(...), FirstAttribute ..., SecondAttribute ..., ... )go CREATE INDEX idx_Users_Code ON dbo.Users(Code) go CREATE TABLE dbo.Links ( UserId1 int not null, UserId2 int not null, Weight ..., CONSTRAINT pk_Links PRIMARY KEY CLUSTERED (UserId1, UserId2) )go
Object store is most likely an overcomplication in this case.
Jenda
Enoch was right!
Enjoy the last years of Rome.
|
|---|