View Issue Details

This bug affects 7 person(s).
 50
IDProjectCategoryView StatusLast Update
17216Bug reportsQuestion editorpublic2022-10-11 10:01
Reporterblocka Assigned Togabrieljenik  
PrioritynoneSeverityminor 
Status feedbackResolutionopen 
Product Version3.25.20 
Summary17216: 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.

TagsNo tags attached.
Bug heat50
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) 

Users monitoring this issue

User List Haris.Pap, Mazi

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

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.

gabrieljenik

gabrieljenik

2022-06-01 01:34

manager   ~70149

Hello blocka,
This ticket has been open for quite some time.
Do you have any new info / feedback?
Can you please check if this issue still exists in the latest version of LimeSurvey and let us know?
Thank you!

Haris.Pap

Haris.Pap

2022-10-07 09:45

reporter   ~72159

Hi everyone
Confirmed, this issue persists in LimeSurvey 5.4.2+220921, tested with a survey of approximately 400 questions.
Saving takes more than 5 minutes (my steps: 1. Delete language, 2. save)

Haris.Pap

Haris.Pap

2022-10-07 09:49

reporter   ~72160

Re-ordering of questions takes similarly a very long time - but I am not sure, if this is directly related (?)

gabrieljenik

gabrieljenik

2022-10-07 19:33

manager   ~72168

Have LSA/LSS ?

Haris.Pap

Haris.Pap

2022-10-11 10:01

reporter   ~72189

Yes, I am sending you an .lsa privately. Thanks for checking.

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
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
2021-12-14 08:57 guest Bug heat 14 => 20
2021-12-14 12:10 guest Bug heat 20 => 26
2021-12-14 13:31 guest Bug heat 26 => 32
2021-12-19 22:13 guest Bug heat 32 => 38
2022-06-01 01:34 gabrieljenik Assigned To => gabrieljenik
2022-06-01 01:34 gabrieljenik Status new => feedback
2022-06-01 01:34 gabrieljenik Note Added: 70149
2022-06-01 01:34 gabrieljenik Bug heat 38 => 40
2022-10-07 09:45 Haris.Pap Note Added: 72159
2022-10-07 09:45 Haris.Pap Bug heat 40 => 42
2022-10-07 09:46 Haris.Pap Issue Monitored: Haris.Pap
2022-10-07 09:46 Haris.Pap Bug heat 42 => 44
2022-10-07 09:49 Haris.Pap Note Added: 72160
2022-10-07 19:33 gabrieljenik Note Added: 72168
2022-10-11 10:01 Haris.Pap Note Added: 72189
2022-11-02 09:55 gLf Bug heat 44 => 50