Reply to Re: what is better - one field or eight - mysql bit testing

Your name:

Reply:


Posted by Jerry Stuckle on 05/17/06 21:53

Kenneth Downs wrote:
> Bent Stigsen wrote:
>
>
>>Kenneth Downs wrote:
>>
>>
>>>>>But of course don't take my word for it. Make it a point to try them
>>>>>both in your travels, and see which one turns out easier on a system
>>>>>that grows over time.
>>>>
>>>>Just answer this question: Given the original scenario of this thread.
>>>>When it is requested for another characteristic to be added, which
>>>>design requires less (possibly zero) work to adapt to this new
>>>>requirement.
>>>>
>>>>
>>>
>>>Mine.
>>>
>>>Because my tools allow me to change my structures easily, and my
>>>framework adapts accordingly.
>>
>>Well then lets compare worklist.
>>
>>Here is mine:
>>- insert record in table with characteristics.
>>
>>
>>What does your look like?
>>
>>
>>/Bent
>
>
> How much code will you write to support the new value? Any? Do you know?
>

That's his (and my) point. None.

> How will you propagate your changes from test to production? Will your
> collaborators know you did this? Do you have only one customer running
> this code or several?
>

insert record in table with characteristics in production system.

> How is the new value documented, do you need to document it?
>

Self-documenting.

> Are there constraints on allowed values? Does the presence of the new value
> affect others columns in other tables?
>

Whatever constraint the customer wants to put on it. And no, it does not affect
other columns in the table.

> Do any flags exclude other flags? Do any flags require any other flags?
>

Nope.

> As I've said now three times in the thread, we don't know, we're just
> playing hypotheticals. If and only if none of these questions matters,
> than go with your cross-reference, because you are talking about user data
> then. (In fact by definition you should not then be doing it, they should
> be putting it in). But if even one of them matters than you aren't done
> yet.
>

You're adding a new CHARACTERISTIC. Whether or not they have wi-fi facilities
has absolutely nothing to do with the color of their windows. That was in the
original definition of the problem - these are independent characteristics.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original 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

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