- Posts: 59
- Karma: 3
- Thank you received: 7
how to design a 500+questions survey?
Am I suppose to see error message when I reach the limit of column? If anyone have experience of reaching limit. Please share. I use local php server (easyPHP: APACHE 2.4.4 MYSQL 5.6.11 PHP 5.5.0)
Just wondering why not use InnoDB as default as it has many more features? (i.e. Transactions, Row Locking, Relational base design , etc).
Just a thought
With MyISAM you have at least the chance to have more than 1000 - as already said it depends on the question types and number of subquestion how many you really have.
And, we don't need row locking or transactions - survey participants primarily write, administrators read. There is rarely a different scenario, so advanced InnoDB features are beaten by the faster MyISAM engine.
LimeSurvey project leader
- Posts: 10505
- Karma: 408
- Thank you received: 1863
Near the max: 728 question + 670 sub question
c_schmitz wrote: With MyISAM you have at least the chance to have more than 1000 - as alread said it depends on the question types and umber of subquestion how many you really have.
the problem is mysql database design, ls has no a robust database design foundation. eg, put all things in one table.that's not best database design concept.tha's almost the most important thing of a system.
Just out of curiosity: Who fills a 1000 question survey? I am sure this is is a very special case.
If you use many conditions and filters you don't need to fill out 1000 questions.
holch wrote: Just out of curiosity: Who fills a 1000 question survey? I am sure this is is a very special case.
Wonder if the php session file for every user would be even bigger with a 1000 questions survey than with simple surveys, where every user got a 1 to 1,6 MB session file created, when starting the survey. That is a problem with session files on tmp partitions.
For me "Big data" starts if a database is 500GB and more.
Would be interesting to see some database designs of other applications with survey elements.
The meaning of the word "stable" for users
Even an insane 1 hour CAPI questionnaire that we had to run some time ago should get anywhere close to that. Loads of conditions and paths depending on specific vehicle models that the respondent had to own would hide many of the questions and it still took easily 1 hour to fill, even with experienced interviewers. I need to find this monster again, but my guess would be about 200-300 questions.