Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

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

is there performance problem when all questions in one table? 9 Monate 3 Wochen her #109598

  • iscar
  • iscars Avatar
  • OFFLINE
  • Gold Lime
  • Beiträge: 226
  • Dank erhalten: 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?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

is there performance problem when all questions in one table? 9 Monate 3 Wochen her #109604

  • holch
  • holchs Avatar
  • ONLINE
  • LimeSurvey Team
  • Beiträge: 3318
  • Dank erhalten: 441
  • Karma: 140
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!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

is there performance problem when all questions in one table? 9 Monate 3 Wochen her #109605

  • iscar
  • iscars Avatar
  • OFFLINE
  • Gold Lime
  • Beiträge: 226
  • Dank erhalten: 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.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

is there performance problem when all questions in one table? 9 Monate 3 Wochen her #109665

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6952
  • Dank erhalten: 929
  • Karma: 277
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.
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.123 Sekunden
Donation Image