koen

What's the best thing to do keeping speed in mind:

1) having 10 "y or n" columns in a db.
2) having 1 column with holds all the values and letting PHP do the
work. Example -> "1|2|3|4|5|6|7|8|9|10" OR "1|4|5|7|8|10" OR "7"

TNX,
Koen

jerry stuckle

If speed is such a problem, you need a faster server.

Seriously - the speed difference won't be that great. Make it 10
columns and save yourself the headaches.

But potentially a better solution would be a second table with key and
value. Link to the first table key and enter only the 'Y' values.

Of course, I don't know your application so I can't say which would be
best for you.

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

koen

tnx, Jerry,
actually speed isn't a problem at all, was just thinking about this one.

Anyone ever saw a site with mysql performance tests like "this
situation" compared to "that situation", it would be interesting.