Check out the LimeSurvey source code on GitHub!

Large database & performance issues

More
5 years 2 weeks ago #73727 by mark01
My design has 13 countries with 13 retail categories. If my client is perceived to be expensive in any category an additional question consisting of local shops is shown and respondents indicate which shops are cheaper [multimention]. So potentially there will be many columns in the DB [If 10 shops in each it would be 13x13x10=1690]!
There would also be 13x13=169 pages that may or may not show up in the survey.
For any country the max number of pages would be 13.

Would it wiser to have seperate questionnaires by country?
If I went the one questionnaire route - would performance be affected?
Regards
Mark

Please Log in to join the conversation.

More
5 years 2 weeks ago - 5 years 2 weeks ago #73732 by DenisChenu
Hello,

Think the best is one survey by country.

Maybe you can use a first survey with country-selector, and use end-url to go to the second survey ( use SGQA for the second survey, maybe some js).

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
Last Edit: 5 years 2 weeks ago by DenisChenu.

Please Log in to join the conversation.

More
5 years 2 weeks ago #73746 by Mazi
At first I would check if you might run into any DB problems with that amount of columns at the central lime_survey_12345 table, see docs.limesurvey.org/General+FAQ&structur...egarding_survey_size

For later analysis keeping it all in one survey is easier. If you split it up into questions for different countries, you have to pass some ID information to connect data later on. It will also be different if a user has to fil several of the country surveys because you have to pass the ID from one to another somehow.
Another alternative might be to load the list of shops dynamicaly using an Ajac call, see docs.limesurvey.org/Workarounds%3A+Manip...ulate_several_fields


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
5 years 2 weeks ago #73763 by mark01
Thanks Mazi - the first reference is of great help. Thanks again. Mark

Please Log in to join the conversation.

More
5 years 2 weeks ago #73770 by Mazi
You're welcome!


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form