Well, obviously, i'm not sure about any aspect of this problem.

If both of you agree, I guess i should try.

I will.

thanks for your attention and your answers.

If both of you agree, I guess i should try.

I mean at some point you need to try and start trouble shooting or circleing the issue. As we do not experience these issues at the moment, we can't reproduce.

If you provide your LSS, we could see if it has the same impact on our system. But I will not generate 650 Questions in 2 languages to simultate something. Even if it would work for me without problems, this still doesn't proof anything, if it isn't the same survey as your's.

Well, I think the results are already clear:

First, I have made a copy of the survey-master. Time to copy: 1:43"

Survey copy summary

Surveys:    1
Languages:    2
Questions Groups:    30
Questions 633
Question Attributes:    9532
Options:    95
Subquestions:    2125
Predetermined Answer Options:    0
Evaluations:    0
Quotas:    0
Members Quota:    0
Language quota Config.    0
Temas:    1402

Then I made the changes that we usually have to make: change admin name, change basic notification email, Activate survey and change to restricted access. Then, deactivate the survey again to delete new groups of questions.

Action 1: Deleted 5 groups - 30 questions: Formulas
Action 2: Deleted 2 groups - 6 questions (Welcome and demographics) and Text elements: Description and goodbye Message in Surveys configuration menu
Action 3: Deleted 6 groups - 168 questions:  Multiple numerical input (Type: K)
Action 4: Deleted 5 groups - 150 questions:  Multiple numerical input (Type: K)

                                                A1        A2        A3       A4
change admin name:             2:41"    2:10"    1:25"    53"
change basic not. email:       2:32"    2:05"    1:10"    41"
Activate survey:                      23"       15"        19"    17"
change to restric.access:       15"        13"       11"     12"
Deactivate survey:                 16"        13"       10"      9"

I would say that the pattern is clear. Yoour comments are really welcome.

Thanks a lot for your interest.
 

Yes, while we still can't exclude for sure that it isn't due to some specific equations and conditions, your test looks pretty consistent in terms of impact of deleting elements / questions / groups from the survey.

Temas: 1402

What does this mean? Do you have 1402 survey themes?

a quality hosting provider with a dedicated server

How are you connected to the database and what database is used? MySQL, MSSQL, Postgre, etc? Is the database on the same server or on a different server?

jelo wrote:

Check what happens when using LimeSurvey 5.6.56.
 

What version are you using now? Did you update? What version of PHP is used?
Your tests show a near linear relation between amount of questions/groups and duration of tasks.
That looks like a code issue which might be a bug in the LimeSurvey code base or in PHP.
 

For information, developer currently try to improve speed.

For your issue : maybe you can report community.limesurvey.org/bug-tracker/ ?

And try activating debugsql maybe : there a lot more SQL request in 5X than in 3.X
Server configuration are very ipportant too : for example you need to deactivate network check for virus for windows IIS

Hi to all of you,

Some more data about our configuration:

SERVER:  4 cpu cores and 8GB RAM
- Debian 11
- MySQL 8.0 (database is on the same server)
- Apache 2.4
- PHP 8.0

Limesurey version: 5.6.26+230613
We are in the middle of a survey campaign now. We will not update the version until it is finished.


"What does this mean? Do you have 1402 survey themes?"  
When a survey is copied, a list of all copied items is displayed at the end of the process. "Temas" is the last line that appears in the list, but as I have the interface in Spanish I don't know what it corresponds to. Obviously, we do not have 1402 interface themes.


"And try activating debugsql maybe : there a lot more SQL request in 5X than in 3.X"
We have had the hosting service technicians checking the server and database activity when we do any of these time-consuming operations. They have not seen anything particular during that process.

again, thank you very much for your answers

roblej wrote:

Hi to all of you,

Some more data about our configuration:

SERVER:  4 cpu cores and 8GB RAM
- Debian 11
- MySQL 8.0 (database is on the same server)
- Apache 2.4
- PHP 8.0[/code]It must work good with such server. Maybe some SQL improvment and some memory assigned to PHP

roblej wrote:

"And try activating debugsql maybe : there a lot more SQL request in 5X than in 3.X"
We have had the hosting service technicians checking the server and database activity when we do any of these time-consuming operations. They have not seen anything particular during that process.

If you have working survey : don't activate debugsql

Some of future improvement here : github.com/LimeSurvey/LimeSurvey/pull/3785 github.com/LimeSurvey/LimeSurvey/pull/3786 github.com/LimeSurvey/LimeSurvey/pull/3787

Sorry for quote broken : i can not edit here …

Just in case you haven't solved this yet, the issue is comfort update. I went into configuration->plugins and disabled comfort update and just like that it was quick as could be!

Hi,

you mean ComfortUpdateChecker? Mine is already disabled



thanks for your answer