[thelist] Survey answers schema
Bill Moseley
moseley at hank.org
Thu Jun 8 15:33:31 CDT 2006
On Thu, Jun 08, 2006 at 02:10:23PM -0600, Ken Moore wrote:
> It is important to remember that presenting data (reports) is very
> different from processing data. As a matter of fact, ?This is my answer?,
> ?Blue?, and ?217? are all text. If what you need is reports, all you do is
> simply convert all answers to text and you are done.
>
> If you need do calculations with a number field, convert back and then
> process.
I wonder how much of a hit that is if trying to use the database to
calculate the variance a large dataset. Suppose it depends on how
big that data set is.
--
Bill Moseley
moseley at hank.org
More information about the thelist
mailing list