- Posts: 42
- Thank you received: 6
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
how to design a 500+questions survey?
- david2013
- Offline
- Senior Member
Less
More
9 years 5 months ago - 9 years 5 months ago #113953
by david2013
Replied by david2013 on topic how to design a 500+questions survey?
It seems like we can have more than 1000 columns. I create a testing survey. 16 groups. each group contains 1 multiple choice question. And each multiple question contains 100 items. So I have around 1600 columns in the result table. It seems fine. (i.e. I can test it and export the data).
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)
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)
Last edit: 9 years 5 months ago by david2013.
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
9 years 5 months ago - 9 years 5 months ago #113955
by Mazi
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Replied by Mazi on topic how to design a 500+questions survey?
You can always test if you reach the column limit by (temporarily) activating the survey.
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Last edit: 9 years 5 months ago by Mazi.
The topic has been locked.
- david2013
- Offline
- Senior Member
Less
More
- Posts: 42
- Thank you received: 6
9 years 5 months ago - 9 years 5 months ago #113989
by david2013
Replied by david2013 on topic how to design a 500+questions survey?
I tested it as I mentioned previously. I think I know why I can have more than 1000 columns. It seems Limesurvey use MyISAM as default storage engine. (See database_helper.php: $sOptions='ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci'
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
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
Last edit: 9 years 5 months ago by david2013.
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
9 years 5 months ago #113992
by Mazi
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Replied by Mazi on topic how to design a 500+questions survey?
To my knowledge InnoDB uses more bytes per column and thus limits the amount of total questions even more which is the main reason we are still using MyISAM.
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
- iscar
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 169
- Thank you received: 0
9 years 1 month ago #117769
by iscar
Replied by iscar on topic how to design a 500+questions survey?
i think lots of problems will happen if we have no a high level mysql design.
we are in big data or die
we are in big data or die
The topic has been locked.
- c_schmitz
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 301
- Thank you received: 84
9 years 1 month ago - 9 years 1 month ago #117771
by c_schmitz
Best regards
Carsten Schmitz
LimeSurvey project leader
Replied by c_schmitz on topic how to design a 500+questions survey?
InnoDB only supports 1000 columns at a maximum.
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.
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.
Best regards
Carsten Schmitz
LimeSurvey project leader
Last edit: 9 years 1 month ago by c_schmitz.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13624
- Thank you received: 2490
9 years 1 month ago #117815
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic how to design a 500+questions survey?
Near the max: 728 question + 670 sub questionc_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.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- iscar
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 169
- Thank you received: 0
9 years 1 month ago #117854
by iscar
Replied by iscar on topic how to design a 500+questions survey?
in big data time, we always need a survey with over 1000 questions,i think myisam is good choice.
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.
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.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11645
- Thank you received: 2738
9 years 1 month ago #117855
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic how to design a 500+questions survey?
"Big data" usually isn't collected in survey style but comes from other sources.
Just out of curiosity: Who fills a 1000 question survey? I am sure this is is a very special case.
Just out of curiosity: Who fills a 1000 question survey? I am sure this is is a very special case.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
9 years 1 month ago - 9 years 1 month ago #118247
by jelo
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
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic how to design a 500+questions survey?
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
www.limesurvey.org/forum/development/117...ord-stable-for-users
Last edit: 9 years 1 month ago by jelo.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11645
- Thank you received: 2738
9 years 1 month ago #118249
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic how to design a 500+questions survey?
Maybe not everyone will fill 1000 questions, but still, this is well beyond most questionnaires that I have ever seen.
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.
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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11645
- Thank you received: 2738
9 years 1 month ago #118250
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic how to design a 500+questions survey?
By the way: are you a sleep walker? Its 3am over there already... go and sleep!
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.