RE: [PHP-DB] Column Defualts
| From: | Peter Beckman | Date: | Tue, 29 Oct 2002 20:03:43 +0000 |
| Subject: | RE: [PHP-DB] Column Defualts | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22794@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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/
---------------------------------------------------------------------------