You are here: NULL fields in table - efficiency question « PHP SQL « IT news, forums, messages
NULL fields in table - efficiency question

Posted by David Smithz on 03/04/07 17:44

I have read it is better to always have all the fields in a table set to
NOT NULL as this makes it much quicker.


In one case I have a table where all fields qualify for this accept for one
which is comments. This will only sometimes be filled.

Am I therefore better off making this field still to be Not NULL and set the
default value to a single arbitrary character such as "." or is this
actually making things less efficient.



Input welcomed. Thanks in advance.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация