is there performance problem when all questions in one table?

Mehr
3 Jahre 1 Monat her #109598 von iscar
iscar erstellte das Thema is there performance problem when all questions in one table?
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?

Bitte Anmelden um der Konversation beizutretten.

Mehr
3 Jahre 1 Monat her #109604 von holch
holch antwortete auf das Thema: is there performance problem when all questions in one table?
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)

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Bitte Anmelden um der Konversation beizutretten.

Mehr
3 Jahre 1 Monat her #109605 von iscar
iscar antwortete auf das Thema: is there performance problem when all questions in one table?
suppose i have 200 surveys. each survey has 50 questions. totally have 10000 questions.
these 10000 questions record in lime_questions table together.

Bitte Anmelden um der Konversation beizutretten.

Mehr
3 Jahre 1 Monat her #109665 von DenisChenu
DenisChenu antwortete auf das Thema: is there performance problem when all questions in one table?
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.

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).
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden um der Konversation beizutretten.

Haben Sie schon bei unserer Kundenumfrage mitgemacht?

Verpassen Sie nicht Ihre Chance auf tolle Preise.

Klicken sie hier um teilzunehmen:

Jetzt starten

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten