Tech Off Post

Single Post Permalink

View Thread: Question - What would you do?
  • User profile image
    Sven Groot

    W3bbo said:
    Maddus Mattus said:
    *snip*

    The effect is negligible. an int is 32 bits, a datetime is 64 bits. On an x64 DBMS the int would be padded out to 64-bits to fit into a word size, so it's possible that the overhead is with using an int rather than a 64-bit type Wink

    On an x64 DBMS the int would be padded out to 64-bits to fit into a word size

    That comment makes no sense whatsoever. For one thing, word alignment only really applies to memory, not persisted storage. For another, x64 still aligns ints on 32 bit boundaries.