View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
17216 | Bug reports | Question editor | public | 2021-03-30 19:47 | 2021-04-07 16:41 |
Reporter | blocka | Assigned To | |||
Priority | none | Severity | minor | ||
Status | new | Resolution | open | ||
Product Version | 3.25.20 | ||||
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 | ||||
Browser | |||||
Database & DB-Version | mariaDB 10.3 | ||||
Server OS (if known) | CentOS | ||||
Webserver software & version (if known) | Apache | ||||
PHP Version | 7.3 | ||||
Thank you ! | |
On shnoulle.limequery |
|
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). https://forums.limesurvey.org/forum/can-i-do-this-with-limesurvey/124120-very-slow-save-times-on-large-survey |
|
@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. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
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 |