Welcome, Guest
Username: Password: Remember me

TOPIC: Large database & performance issues

Large database & performance issues 2 years 2 months ago #73727

  • mark
  • mark's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 74
  • Karma: 0
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
The administrator has disabled public write access.

Re: Large database & performance issues 2 years 2 months ago #73732

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5838
  • Thank you received: 714
  • Karma: 222
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
Last Edit: 2 years 2 months ago by DenisChenu.
The administrator has disabled public write access.

Re: Large database & performance issues 2 years 2 months ago #73746

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5278
  • Thank you received: 289
  • Karma: 246
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)limesurvey.org'"
The administrator has disabled public write access.

Re: Large database & performance issues 2 years 2 months ago #73763

  • mark
  • mark's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 74
  • Karma: 0
Thanks Mazi - the first reference is of great help. Thanks again. Mark
The administrator has disabled public write access.

Re: Large database & performance issues 2 years 2 months ago #73770

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5278
  • Thank you received: 289
  • Karma: 246
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)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.107 seconds
Donation Image