Mombu the Programming Forum sponsored links

Go Back   Mombu the Programming Forum > Programming > What is best mysql practice in this case
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 24th February 10:01
koen
External User
 
Posts: 1
Default What is best mysql practice in this case?


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
  Reply With Quote


  sponsored links


2 24th February 10:01
jerry stuckle
External User
 
Posts: 1
Default What is best mysql practice in this case?


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
==================
  Reply With Quote
3 24th February 10:01
koen
External User
 
Posts: 1
Default What is best mysql practice in this case?


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.
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666