Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : is there performance problem when all questions in one table?

is there performance problem when all questions in one table? il y a 3 mois 1 semaine #109598

  • iscar
  • Portrait de iscar
  • Hors ligne
  • Gold Lime
  • Messages : 182
  • Remerciements reçus 1
  • Karma: 0
i just found all survey questions record in 1 table.
i am not familiar with mysql.say more than 10 thousands question in mysql table, is that will cause performance problem?
L'administrateur a désactivé l'accès en écriture pour le public.

is there performance problem when all questions in one table? il y a 3 mois 1 semaine #109604

  • holch
  • Portrait de holch
  • Hors ligne
  • LimeSurvey Team
  • Messages : 2666
  • Remerciements reçus 318
  • Karma: 119
What do you mean with 1000 questions?

10.000 respondent questionnaires? --> Should be no big deal
10.000 questions in one questionnaire? --> You will run into the limits of the database for columns per table (depends on the database engine use - there is some information about this in the manual)
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
L'administrateur a désactivé l'accès en écriture pour le public.

is there performance problem when all questions in one table? il y a 3 mois 1 semaine #109605

  • iscar
  • Portrait de iscar
  • Hors ligne
  • Gold Lime
  • Messages : 182
  • Remerciements reçus 1
  • Karma: 0
suppose i have 200 surveys. each survey has 50 questions. totally have 10000 questions.
these 10000 questions record in lime_questions table together.
L'administrateur a désactivé l'accès en écriture pour le public.

is there performance problem when all questions in one table? il y a 3 mois 1 semaine #109665

  • DenisChenu
  • Portrait de DenisChenu
  • Hors ligne
  • Moderator Lime
  • Messages : 6318
  • Remerciements reçus 812
  • Karma: 242
Hi,

No, not a major issue here : SQL is done for this :
Same time to load one line .

We only load one line at a time. (Sometime all of the survey). All not loaded question don't take time.
The biggest issue in time is the DATA transfer from SQL to memory.
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.129 secondes
Donation Image