Dependency Graph

Dependency Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

This bug affects 2 person(s).
 14
IDProjectCategoryView StatusLast Update
17216Bug reportsQuestion editorpublic2021-09-21 15:42
Reporterblocka Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version3.25.20 
Summary17216: Large survey with many questions with conditions very slow to save.
DescriptionA 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 ReproduceOpen survey, edit an question, save the question -- wait up to 60 seconds for the save to complete.
TagsNo tags attached.
Bug heat14
Complete LimeSurvey version number (& build)3.25.6 201229 or later
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmariaDB 10.3
Server OS (if known)CentOS
Webserver software & version (if known)Apache
PHP Version7.3

Relationships

related to 17107 acknowledgedc_schmitz Survey seems without any question when testing (admin user) 

Activities

blocka

blocka

2021-03-30 19:47

reporter  

survey_473553.zip (77,019 bytes)
DenisChenu

DenisChenu

2021-03-30 20:28

developer   ~63729

Thank you !
DenisChenu

DenisChenu

2021-03-30 20:33

developer   ~63730

On shnoulle.limequery
blocka

blocka

2021-04-01 21:02

reporter   ~63786

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.
c_schmitz

c_schmitz

2021-04-02 14:17

administrator   ~63787

Last edited: 2021-04-02 14:17

View 2 revisions

How did you notice all conditions were removed?
DenisChenu

DenisChenu

2021-04-02 14:59

developer   ~63788

@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
c_schmitz

c_schmitz

2021-04-07 08:36

administrator   ~63849

@blocka: How did you notice all conditions were removed? Were they gone n the interface? Or did the survey just not use them?
blocka

blocka

2021-04-07 16:41

reporter   ~63855

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.

Issue History

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
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