Heeh. That's not a random blog post, that's the official manual :-p

If it's in there, it's pretty much trustworthy; and I've learned something new 
:-) So apparently there's a dedicated "NULL" bit to columns... Yes, then there 
would be a small performance benefit.

I stand corrected. Still, as you've noticed, don't change the design of an 
existing application without thoroughly testing the consequences :-p


----- Original Message -----
> From: sono...@fannullone.us
> To: mysql@lists.mysql.com
> Sent: Tuesday, 14 June, 2011 7:34:04 PM
> Subject: Re: Data missing after field optimization
> 
> It took me awhile, but I just found it again, in case anyone is
> interested:
> 
> http://dev.mysql.com/doc/refman/5.0/en/data-size.html
> 
> 
> 7.8.1. Make Your Data as Small as Possible
> 
> Declare columns to be NOT NULL if possible.  It makes everything
> faster and you save one bit per column. If you really need NULL in
> your application, you should definitely use it.  Just avoid having
> it on all columns by default.
> 
> Marc

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to