| [solved] Performance using INT/SMALLINT [message #636] |
Thu, 25 January 2007 04:45  |
 texnoti
Messages: 3
Registered: January 2007
Location: Stockholm |
Junior Member |
|
|
Hi!
Perhaps this is a question for INTEL or likewise but i figured someone would know.
I nag about using apropriate type for integer (and other). Don't use INT when TINYINT is enaugh. That way storage space is saved.
But last week someone mentioned that what you win in storage is lost in execution.
INT require 4 bytes and SMALLINT 2 bytes. The theory was that it's faster to calculate with 4 bytes than with 1, 2 or 3 bytes and that the processor (?) anyway padds (or truncate) the value to 4 bytes.
Something to do with 32-bit processor and that 32/2=> 16/2=8
Anyone who can explain this?
Rgds
thomas
[Updated on: Thu, 25 January 2007 05:08]
http://www.reklamberget.se
|
|
|
|
| Re: Performance using INT/SMALLINT [message #638 is a reply to message #637 ] |
Thu, 25 January 2007 04:58  |
texnoti
Messages: 3
Registered: January 2007
Location: Stockholm |
Junior Member |
|
|
Ok, so computing don't get affected by the fact that i store a value as INT or SMALLINT?
http://www.reklamberget.se
|
|
|
|
|
Members
Search
Help
Register
Login
Home
