Posted by Koen on 09/28/43 11:35

Jerry Stuckle wrote:
> Koen wrote:
>
>> 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
>
>
> 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.
>

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.

[Back to original message]