Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Houston
    Posts
    2

    Unhappy Unanswered: Redundancy server Keys

    I feel like a fool having used auto-numbers for our keys, now we have multi systems and wishing to sync them. Any ideas on a way to create a unique key where no 2 keys will be the same even if created at the same time.

    Thanks in an advance...

    Glen Whiting
    gwhiting_928s4@hotmail.com

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: Redundancy server Keys

    Originally posted by God Boy
    I feel like a fool having used auto-numbers for our keys, now we have multi systems and wishing to sync them. Any ideas on a way to create a unique key where no 2 keys will be the same even if created at the same time.

    Thanks in an advance...

    Glen Whiting
    gwhiting_928s4@hotmail.com
    Handle auto numbers yourself. Have a table that looks like:

    SEQ_NAME VARCHAR(30)
    SEQ_COUNTER INTEGER
    SEQ_INCREMENT INTEGER

    If you want to avoid contention (a lot of apps/connections requesting a sequence on a table), set the increment to a value that is equal to your average number of simultaneous connections (your buffer your sequences).

    Hope this helps.

  3. #3
    Join Date
    Jun 2003
    Posts
    21

    Re: Redundancy server Keys

    Originally posted by God Boy
    I feel like a fool having used auto-numbers for our keys, now we have multi systems and wishing to sync them. Any ideas on a way to create a unique key where no 2 keys will be the same even if created at the same time.

    Thanks in an advance...

    Glen Whiting
    gwhiting_928s4@hotmail.com
    If you're on a Windows platform use GUID's (Global Unique Identifiers).

Posting Permissions

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