Re: Survey with many columns
Date: Wed, 20 Aug 2003 22:11:49 GMT
Message-ID: <FmS0b.210485$4UE.203778_at_news01.bloor.is.net.cable.rogers.com>
You should make a generic data structure for surveys.
That way you can always create surveys without changing your table structure.
I've done this a few times with great success.
"Philipp Lenssen" <philipp.lenssen_at_bb-k.com> wrote in message
news:MPG.19a725bec39f6efe98968e_at_News.Individual.DE...
> My colleague is working on a project which should store data from a long
> survey. His single table now has many, many columns (labelled "a_1_1"
> and so on), with different data types (some boolean, some integers, some
> text, and so on).
>
> Is there a way to optimize this?
> E.g. what would be if the next survey comes along, one which has
> different fields. Would everything need to be redone from scratch?
Received on Thu Aug 21 2003 - 00:11:49 CEST