Here’s the scenario. I have a main tree-like table (actually it’s more
of a hierarchy), where the entries (or at least some of them) can be
categorised as one or more of a fixed number of types (prob about 6 poss
types). So an entry could be a Type A and a Type D; a Type C, D, E; just
a Type F; etc.
Having a join table would seem like it might get rather expensive since
I’m going to want to know the types each time I call an entry. Seemed an
obvious way would be to use an integer and bitwise ops, so that each bit
in the integer represrented a type which could be on or off.
Does anyone have any comments re the wisdom or otherwise of doing this?
Would the benefits be outweighed by the calculation overhead? Any better
way that I haven’t thought of?
Cheers in advance
(p.s. I’m using MySQL at the moment)