[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