Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

[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 Report message to a moderator

	[solved] Performance using INT/SMALLINT By: texnoti on Thu, 25 January 2007 04:45
	Re: Performance using INT/SMALLINT By: Peter on Thu, 25 January 2007 04:51
	Re: Performance using INT/SMALLINT By: texnoti on Thu, 25 January 2007 04:58
	Re: Performance using INT/SMALLINT By: Peter on Thu, 25 January 2007 05:02
	Re: [solved] Performance using INT/SMALLINT By: texnoti on Thu, 25 January 2007 05:09

Previous Topic:	Connecting to Mysql with ODBC vs C library
Next Topic:	slow query

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]