Globally Unique Identifiers (GUIDs)

Results 1 to 3 of 3

Thread: Globally Unique Identifiers (GUIDs)

  1. #1
    Chris O'Connor Guest

    Default Globally Unique Identifiers (GUIDs)

    Has anybody ever used a GUIDs for a distributed database? If so, was it beneficial? Any problems? I'm debating between creating a concatenated primary key with a TableID and LocationID for each table in a distributed database or using GUIDs instead.

  2. #2
    Join Date
    Dec 1969

    Default RE: Globally Unique Identifiers (GUIDs)

    We have been using GUID's for over a year now and have had no issues. Not knowing how you want to use them though I don't want this to be an endorsement. For our application they have had a number of advantages and seemingly no downside.

  3. #3
    Richard A. Lowe Guest

    Default RE: Globally Unique Identifiers (GUIDs)

    Although I haven&#039;t used them, I favour them to your first idea. The concatenated key seems to me to be less flexible (although I can&#039;t think of counterexamples right now). GUIDs seem more flexible and are certainly more able to keep your data unique.<BR><BR>Richard

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts