View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|17216||Bug reports||Question editor||public||2021-03-30 19:47||2021-09-21 15:42|
|Summary||17216: Large survey with many questions with conditions very slow to save.|
|Description||A survey with 700+ questions and 1100+ conditions is very slow when saving individual questions. |
Issue is worked around by commenting out lines 796, 797, and 987 in /application/controllers/admin/database.php
A thread can be found here: https://forums.limesurvey.org/forum/can-i-do-this-with-limesurvey/124120-very-slow-save-times-on-large-survey
|Steps To Reproduce||Open survey, edit an question, save the question -- wait up to 60 seconds for the save to complete.|
|Tags||No tags attached.|
|Complete LimeSurvey version number (& build)||3.25.6 201229 or later|
|I will donate to the project if issue is resolved||No|
|Database type & version||mariaDB 10.3|
|Server OS (if known)||CentOS|
|Webserver software & version (if known)||Apache|
survey_473553.zip (77,019 bytes)
|Thank you !|
I would like to provide an update -- if you comment out lines 796, 797, and 987, conditions on the questions aren't recalculated -- that is expected.
However, what I have also noticed is that the conditions are then removed for all questions. And running the Survey Logic File doesn't restore them.
I had to uncomment the lines just before the survey went live, open a question, save the question, and then all my conditions were reapplied.
How did you notice all conditions were removed?
@c_schmitz : it's in hacking code, not on limeservice.
Without hacking : ~20 seconds on limeservice (free limeservice)
With hacking (disable reset EM) : No speed issue (on own server).
|@blocka: How did you notice all conditions were removed? Were they gone n the interface? Or did the survey just not use them?|
Conditions were not displayed on the Question summary page, and conditions were not used when I ran the survey.
But once I uncommented the code I had removed, edited and saved a question, the conditions were reapplied to the questions and worked on front-end survey.
|2021-03-30 19:47||blocka||New Issue|
|2021-03-30 19:47||blocka||File Added: survey_473553.zip|
|2021-03-30 20:28||DenisChenu||Note Added: 63729|
|2021-03-30 20:33||DenisChenu||Note Added: 63730|
|2021-03-30 20:33||DenisChenu||File Added: Capture d’écran_2021-03-30_20-33-17.png|
|2021-04-01 21:02||blocka||Note Added: 63786|
|2021-04-02 14:17||c_schmitz||Note Added: 63787|
|2021-04-02 14:17||c_schmitz||Note Edited: 63787||View Revisions|
|2021-04-02 14:59||DenisChenu||Note Added: 63788|
|2021-04-07 08:36||c_schmitz||Note Added: 63849|
|2021-04-07 16:41||blocka||Note Added: 63855|
|2021-04-23 22:36||DenisChenu||Relationship added||related to 17107|
|2021-09-13 14:45||guest||Bug heat||6 => 12|
|2021-09-21 15:42||Mazi||Issue Monitored: Mazi|
|2021-09-21 15:42||Mazi||Bug heat||12 => 14|