I have a node content type that needs to store four different
- Score A
- Score B
- Score C
- Score D
Each node of the content type always has all four
I could store this one of two ways:
- Store all four scores in a single
Integerfield that is limited to four values. (Set Score A to the 0 position, Score B to the 1 position, and so on.) (One field in total)
- Store each of the four scores as its own
Integerfield. (Four fields in total)
From a usability perspective, it's easier to have four fields because it's more obvious where each score is, and configuring views is easier.
However, from the perspective of performance, which is better?