<snip>
>-Performance is a myhth. I haven't yet seen something showing GUIDs perform worse.
>-If your concern is space yes you might be right, it's 16 bytes. Twice of bigint and 4 times of integer. But then think XML. It's used a lot in .Net and it has a lot redundancy in itself. You can live with it:)
>If you can search about it here on UT there are some long running threads. Also google "identity crisis".
>Cetin
Thanks again for your thoughts (and borrowed thoughts <s>)
I am glad to see your statement that GUIDs have relative poor performance. I have been searching the internet for statistics showing that performance is degraded when choosing a GUID as PK compared to (big)int as PK. I hope someone can give me such link (unless is is infact just a myth).
I do not feel space is an issue (I used to think it was an issue about 9 months ago). Disk space is cheep and unlimited (well almost <s>). Now something that I didn't think of (Bonnie brought it to my attention) is bandwidth. I have not yet made up my mind if I think that is a major issue or not (I am searching the web for that too).
Einar
Semper ubi sub ubi.