Koen 2007-02-24 08:01:02
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”
Jerry stuckle 2007-02-24 08:01:03
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
JDS Computer Training Corp.
Koen 2007-02-24 08:01:05
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.