With MySQL you save a bit by declaring a column not null. If it is null, you are using a bit. For performance on high volume and high transaction servers, declaring your columns not null will help, if only slightly. Peter On Tue, 29 Oct 2002, Ryan Jameson (USA) wrote: > No, I believe all databases have an isnull bit flag to go with any column > stored. So whether you set it or not the bit is being used. > > <>< Ryan > > -----Original Message----- > From: Gerard Samuel [mailto:gsam@trini0.org] > Sent: Tuesday, October 29, 2002 9:47 AM > To: php-db > Subject: Column Defualts > > > Is defaulting a column to NULL considered as a waste of space?? > I have a table that has 2 columns (so far) that defualt to NULL, and > potentially, > there can be good amount of rows with NULL. Just wondering... > > -- > Gerard Samuel > http://www.trini0.org:81/ > http://dev.trini0.org:81/ > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > --------------------------------------------------------------------------- Peter Beckman Systems Engineer, Fairfax Cable Access Corporation beckman@purplecow.com http://www.purplecow.com/ --------------------------------------------------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
