The dreaded question about questionnaire database

[gemma-the-husky]

I appreciate the points you are making, but I actually think its a very restrictive view, that ignores all of the advantages and opportunities that a interactive computer programme can provide

I really do not see any point in making a questionaire debrief look like the questionaire itself.

I am sure there are better ways to do it.

 

[themurph2000]

OK, I've read through all of that, and now I'm more confused. :banghead:

I'm in a situation like this right now, and my biggest concern is reducing the size of the questionnaire database (over 800MB right now). There are things I can clean up (like substituting Employee IDs for their actual names), and thankfully the majority of questions on the survey have a series of 1 or 2 sets of checkboxes, each of which with an either/or scenario. At most, that gives 9 permutations of the checkboxes for those questions.

Right now, I'm attempting to take those 35 fields in my questionnaire and convert them to an integer format rather than a text format, thus getting rid of a lot of repeated text by using a link to a smaller table with the 9 permutations of the checkboxes. I'm hoping reducing the number of text fields (and the fact whoever did this never thought to reduce the field size of them) to save room in the database.

If anyone has other suggestions, particularly where to look to find why my database is so bloated, I welcome them.