Posted by Jerry Stuckle on 09/28/80 11:35

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.

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

• Next in forum: Re: What is best mysql practice in this case?
• Prev in forum: Re: SEO for dynamically generated product catalogue
• Thread view: Re: What is best mysql practice in this case?

[Reply to this message]