|
Posted by Colin McKinnon on 05/14/06 14:34
Alan Little wrote:
> Carved in mystic runes upon the very living rock, the last words of
> windandwaves of comp.lang.php make plain:
>
>> I have to store up to eight boolean bits of information about an item
>> in my database.
>>
>> There are three ways of storing this information in my mysql database
>> A. add eight fields (tiny integer)
>> B. add one tiny integer and create a function in PHP that can translate
>
> I'd go with B, just my personal preference.
>
You'd get a mouthful if you tried that working for me.
Its a BAD idea. SQL has no visibility of it. It's not normalized and it
doesn't scale. In fairness certain types of search can be done very fast,
but they're unlikely to be particularly common.
C.
Navigation:
[Reply to this message]
|