On Tue, Jun 27, 2006 at 13:43:21 +0200,
Christian Rengstl <Christian.Rengstl@klinik.uni-regensburg.de> wrote:
> Hi list,
>
> i am in the middle of breaking my head over designing a database and came to the following question/problem: i have
personswhose values (integer) have to be entered in the db, but per person the amount of values ranges from 10 to
around50. Now my question is if it makes sense, concerning performance, to store these integer values in arrays or if
itis better to change the design so that the values are stored separately in fields in tables. I have to add, that it
isnot unlikely (or at least it won't happen very often) that select queries will try to find one of those specific
values,but rather something like select * from persons where person_id=...
If the data isn't actually a vector, than it is probably better to not use
arrays. This will provide you with more flexibility.