Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    7

    Unanswered: Performance Issues with INTEGER vs. SMALLINT

    Is there any performance difference between using an INTEGER vs. a SMALLINT datatype? Or is it just space requirements?

    I'd like to use INTEGER just to be sure the datatype is large enough but need to be concerned with anything that can cause performance problems.

    I'm using DB v9.1 on Linux.

    Thanks for the advice.

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by Yadrif
    Is there any performance difference between using an INTEGER vs. a SMALLINT datatype?
    Depends on where and how you're using it, of course.
    If you need to store or pass numbers larger than 3267, the choice is clear.
    If you have to transfer large amounts of small numbers, the choice should also be clear. Even CHAR(1) could be a choice then!
    Computationally, there will probably be little or no difference between manipulating INTs or SMALLINTs since registers are always either 4 or 8 bytes nowadays. Or is SMALLINT arithmetic still done in 2-byte registers?
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Something else to consider is the maximum row length.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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