View Issue Details

This bug affects 1 person(s).
IDProjectCategoryView StatusLast Update
18473Bug reportsSurvey editingpublic2022-12-14 17:42
ReporterDenisChenu Assigned To 
Status newResolutionopen 
Product Version5.4.x 
Summary18473: Survey listing : multiple call of template and group

When goes to survey listing with SQLdebug set : we see multiple call of same rquest

Steps To Reproduce

Steps to reproduce

Activate debug + SQL debug
Goes to survey litsing
Check SQL log

Expected result

Have some SQL with 3 or 15 call

Actual result

Lot of SQL request with bunch of call

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)5.4.10
I will donate to the project if issue is resolvedNo
Database type & versionmariadb
Server OS (if known)debian
Webserver software & version (if known)nginx
PHP Version7.4

Users monitoring this issue

User List There are no users monitoring this issue.




2022-11-09 09:50




2022-11-09 09:51

developer   ~72650

Here : speed is OK because server are local
But with external SQL server : take long time



2022-11-09 12:35

developer   ~72671

I have 4 server on the same network, on public and one internal. 2 for production + 2 for prepoduction , proxy for high availability, SQL server on same network but another server.

The 5.X is the preprod for testing version : the link to the DB server are same all other configuration are same. And BD is just some week old.

For 5.X : i'm connected directly by internal VPN : less network
For 3.X : external + my own VPN (AirVPN) +

Survey listing on 5.X : 20.48 s
Same survey listing on 3.X 2.56s

… it's REALLY unusuable



2022-11-16 11:17

developer   ~72757

Idea one : Use a static array for template (like we do for Survey)



2022-12-14 17:42

developer   ~73122

Idea : better action : move some needed action to findByPk only (when we get THE survey)
See related

Issue History

Date Modified Username Field Change
2022-11-09 09:50 DenisChenu New Issue
2022-11-09 09:50 DenisChenu File Added: 5X_SurveyListing_noplugins.png
2022-11-09 09:50 DenisChenu File Added: 3X_SurveyListing_LOTPLUGINS.png
2022-11-09 09:51 DenisChenu Note Added: 72650
2022-11-09 09:51 DenisChenu Bug heat 0 => 2
2022-11-09 10:00 DenisChenu Summary Surey listing : multiple call of template and group => Survey listing : multiple call of template and group
2022-11-09 12:35 DenisChenu Note Added: 72671
2022-11-16 11:17 DenisChenu Note Added: 72757
2022-12-14 17:42 DenisChenu Note Added: 73122