I checked a different survey, and the problem exists also there - in few first groups everything is ok, and at some point that function starts querying for every question in whole survey.

Carsten passed me this solution - changing
getQuestionAttributes($qrow['qid']);
to
getQuestionAttributes($qrow['qid'], $qrow['type']);
in getArrayFilterExcludesCascadesForGroup function, thanks! :)

Verry weird thing... after passing question type, as Carsten suggested, and saving few hundreds of queries, the script execution time takes much longer.
I'll try to investigate it tomorrow.

Any new findings on this?

I'd like to figure this bug out - is there any chance you could build a survey that you can share, so I can try it?

I've got a file here that replicates the problem:

http://benian.nl/MISC/limesurvey_bug_4787.lss

Steps to reproduce:

• Import survey file
• Make survey active
• Start new participation in active survey
• Check some boxes in the first question
• Enter the answers on the second question
• After submitting the second question it should load extremely slowly ( > 30 seconds) or time-out

(I've tried on my own server and limeservice.com, same problem)

Hey, sorry for not responding. I found that the problem lays somwhere in checkconfield function. Setting "deletenonvalues" to 0 helps, but ofcourse it's not the solution :)

The problem happens in various longer surveys. It looks like in some point of that surveys "checkconfield" function starts to produce a huge number of queries.

I can provide some other surveys if wanted.

As suggested in http://bugs.limesurvey.org/view.php?id=4787#c13688 tried changing in getArrayFilterExcludesCascadesForGroup function:

• getQuestionAttributes($qrow['qid'], $qrow['type']); // Very slow, roughly a minute
• getQuestionAttributes($qrow['qid']); // Slow, roughly 10 seconds

Think I solved the problem by adding a little memory to functions that are called often: getArrayFiltersForQuestion and getArrayFilterExcludesForQUestion

Fixed in svn 9964 by adding cache to some frequently called functions, please reopen if this does not fix the problem

Please don't forget to commit this to _dev branch, too.

done in 9967