Martin Jespersen schrieb:
Does anyone havea clue of how mysql optimizes empty fields and how
query speed is affected?
Why don't you read the part in the mysql documentation about the
opimization?
what will be better for queryspeed/size: adding them with NULL using
NULL as default or with NOT NULL using 0 and '' as defaults?
Depends on what you need!
But Both is okay.
"NULL" woudl just give you more free space since "NULL" don't add any
bytes to the column.
Greetings
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]