Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369

    Question Unanswered: Curiosity question regarding "number size" and performance effects.

    Out of curiosity;

    Given a relevant amount of records, would/could it be faster for a computer to handle ID fields that has its autonumber main index field start from 1 and up to some millions, or if one set the autonumbering to start from - say 1 billion?

    Is it more "work" for a computer to handle the number 1 (seemingly shorter, less zeros and ones...) than to handle the number 1.000.000.000 ? Or is this in db context not relevant?

    D.

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    Assuming it is "typed" the same, no difference.
    Ken

    Maverick Software Design

    (847) 864-3600 x2

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    As practicalprogram is saying, since the field type has to be the same, it doesn't matter what the actual number is. once you've chosen a field type, then the same amount of memory will be allocated to every single value you enter into that field.

  4. #4
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369
    ok, thanks :-)

    D.

Posting Permissions

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