Re: what is better - one field or eight - mysql bit testing
- From: Jerry Stuckle <jstucklex@xxxxxxxxxxxxx>
- Date: Mon, 15 May 2006 09:49:05 -0400
Bent Stigsen wrote:
Jerry Stuckle wrote:
My customers aren't. It's because the databases were designed properly in
the first place.
Sadly not all customers appreciate that. All some care about is the <beep>
dessert topping. I find that a trifle annoying. I utterly refuse to play
along with that. Oh what fun I would have, being a ruthless dictator. chop.
chop.
/Bent
Bent,
Unfortunately, that's true. Some have to go through a messy (and expensive) change cycle to become believers.
At the same time, I've found most databases can be designed with change in mind very quickly. Just properly normalizing the database does wonders. And in a case like the one which started this discussion, thinking ahead - yes, now we have eight options. But would we ever want to add more? If so, a link table is the way to go.
Sometimes it's not obvious. But understanding the data and how it will be used is critical to proper database design.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.
- References:
- what is better - one field or eight - mysql bit testing
- From: windandwaves
- Re: what is better - one field or eight - mysql bit testing
- From: Kenneth Downs
- Re: what is better - one field or eight - mysql bit testing
- From: Bent Stigsen
- Re: what is better - one field or eight - mysql bit testing
- From: Kenneth Downs
- Re: what is better - one field or eight - mysql bit testing
- From: Jerry Stuckle
- Re: what is better - one field or eight - mysql bit testing
- From: Kenneth Downs
- Re: what is better - one field or eight - mysql bit testing
- From: Jerry Stuckle
- Re: what is better - one field or eight - mysql bit testing
- From: Bent Stigsen
- what is better - one field or eight - mysql bit testing
- Prev by Date: Show image img src=img.php?img=1.jpg help
- Next by Date: Re: Addslashes / Stripslashes
- Previous by thread: Re: what is better - one field or eight - mysql bit testing
- Next by thread: Re: what is better - one field or eight - mysql bit testing
- Index(es):
Relevant Pages
|
