- Posts: 11746
- Thank you received: 2750
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
how to design a 500+questions survey?
- holch
- Offline
- LimeSurvey Community Team
And to be honest, I agree with Carsten, 500 questions is really a lot. I guess it is not for market research. Because from my experience, when the questionnaire gets too long, the last questions are actually not worth asking, because no one thinks about the question anymore, but just tries to click through. If they don't drop out.
Anyway. I agree that it would be a great addition if we could have a feature where Limesurvey could add a second table so that more questions can be included. When you have a lot of multipe response questions with a lot of answers, you get to the limit quite quickly.
Maybe you can make a feature request in the bug tracker?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
- Mazi
- Offline
- Official LimeSurvey Partner
We are aware of that problem and have tried to solve it in the past several times. BUT... this requires a major code rewrite and currently we do not have the resources for that.holch wrote: Anyway. I agree that it would be a great addition if we could have a feature where Limesurvey could add a second table so that more questions can be included. When you have a lot of multipe response questions with a lot of answers, you get to the limit quite quickly.
Maybe you can make a feature request in the bug tracker?
We prefer to use our limited resources for several minor improvements instead of spending lots of time on a single feature only with the risk of leaving something unfinished at the end of developers leave or the like.
Anyway, this is on our list and maybe we participate at "Google Summer of Code" next year which would be an option for implementing such a major feature.
Until then you need to split up surveys and pass IDs to hidden questions to merge data later.
...or just don't annoy your users with hundreds of questions
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
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11746
- Thank you received: 2750
I agree. But often Limesurvey is used for things slightly different to what we know as market research, etc. Sometimes it is more a help for data entry, etc.
And with with 10 multipe choice question with 100 items the limit is also reached I guess.
I also agree that this is not the most important feature for sure. If it is so hard to implement, we should focus on other things instead to "waste" all forces on this feature, which I would call "nice to have".
Thank you for the further explanation. Makes things a lot clearer.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
- Ben_V
- Offline
- Platinum Member
- Posts: 1223
- Thank you received: 351
But often Limesurvey is used for things slightly different to what we know as market research, etc. Sometimes it is more a help for data entry, etc.
Yes, and I'm pretty sure that LS will fit, more and more, a lot of those needs.... however my opinion is that people using the software in very special or extreme conditions have to adapt the code themselves; Open-source projects are made for this!
About surveys with +500 questions, I think the most important issue is not the software, but the ability of the coder to configure a very complicated survey using the excel import feature (hard to use LS GUI for this). Personally (and for the moment) I just can rely on one (found here ) :
"The EM author used similar view (a little cleaner) to let his collaborating Epidemiologists and Institutional Review Board validate and authorize surveys with thousands of questions in highly branched and tailored structured interviews"
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
- iscar
- Topic Author
- Offline
- Elite Member
- Posts: 169
- Thank you received: 0
1.it's common to disign a survey of more than 1000 questions. i am not aware of this question till the server speed become slow, then i notice LS mysql database design problem.i think sql database is the base of ls.
2.i am not sql expert. i review the sql database design principle guide just now, it's not recommended to put irrelevant things in 1 table, like all surveys questions.
3.i am not sure what's reason if put much column in 1 table, I/O?
- david2013
- Offline
- Senior Member
- Posts: 54
- Thank you received: 7
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)
- Mazi
- Offline
- Official LimeSurvey Partner
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
- david2013
- Offline
- Senior Member
- Posts: 54
- Thank you received: 7
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
- Mazi
- Offline
- Official LimeSurvey Partner
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
- iscar
- Topic Author
- Offline
- Elite Member
- Posts: 169
- Thank you received: 0
we are in big data or die
- c_schmitz
- Offline
- LimeSurvey GmbH Employee
- Posts: 329
- Thank you received: 89
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
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13907
- Thank you received: 2546
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.