Re: Question about a data structure

Message-ID: <45be9980$0$28162$4c368faf@xxxxxxxxxxxxxx> from Larry in
Honolulu contained the following:

Well I appreciate the answer, and that sounds fine, except with just 1000
entries, that's 150,000 records, and thinking about writing the queries to get
the data out and use it makes my head hurt!

150,000 is still peanuts.

Lets say you have something like this:

answer_id (PK), user_id, question_id, response

Then put users details in a separate table. Questions would also be in
a separate table

question_id(PK), survey_id, question

Getting the answers for a particular user is easy

To get responses you'd have to query the questions table to get all the
questions in an array then loop through this array to get the responses
to the questions.

--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011
.

Relevant Pages

  • Re: Positive/Negative after taking the square root
    ... There were a few replies which mentioned definite integrals (and thus ... Although these responses were very ... to keep track of the separate cases, ... To avoid this ambiguity, could you possibly say let u be the variable ...
    (sci.math)
  • Re: use hash of arrays to sort
    ... For what responses are you thanking people? ... the results of split to an array reference, ... a series of references to arrays containing three strings. ...
    (comp.lang.perl.misc)
  • Re: Variable Length Arrays
    ... I am assuming from the lack of responses that I am being increadibly stupid with that question. ... /* arris an array of variable size specified by the integer somesize */ ... You also asked about incomplete types in your original post. ...
    (comp.lang.c)
  • Re: Arrays in Access.
    ... Hmm, I have so many responses to this post, but I'll restrict myself to the ... The original post didn't state a 1-dimensional array although it is ... talking about ordering the recordset rather than as the OP requested working ...
    (comp.databases.ms-access)
  • Counting survey responses, 4 queries or 1 query??
    ... I have a 'survey' database. ... Survey ID (so I know which responses go with which survey) ... I know it's easy to make separate 'counting' queries to count all the Y ... I would prefer not to use crosstab queries, ...
    (microsoft.public.access.queries)