View Issue Details

This issue affects 2 person(s).
 14
IDProjectCategoryView StatusLast Update
19486Bug reportsSurvey participants (Tokens)public2026-10-26 13:51
Reporterjoanna.hawrysz Assigned Toc_schmitz  
PrioritynoneSeveritycrash 
Status closedResolutionfixed 
Product Version6.4.x 
Summary19486: Slowness and errors when working on a survey with loaded participants
Description

After upgrading to the newest version of lime survey, I've encountered problems with my surveys. Once I have loaded the participants table from csv file, my system slows. The slowness is happening in the survey settings but not in the survey list or the survey itself. The more participants I add the slower system becomes, first slowing down I've noticed was for about 5k loaded participants.

For my largest survey of about 40k participants not only does it take 15+ seconds to load any option (while loading the screen appears grey, see attached file Slowness_appearance), but also in some cases trying to send invites or reminders to the participants shows no response and reloading page throws error (see attached file Error1). Trying to expand number of participants per page at the bottom right of the site works only for about maximum of 250 participants per page (Chrome) or 2500 participants per page (Microsoft Edge) if I try to show more it throws an error as well (see attached file Error2).

The problem exists both for surveys created before and after the update and regardless of size or complexity of the survey. The only thing that seems to affect the speed of response is the number of participants.

Problem was tested both for csv files with only the obligatory attributes (firstname, lastname, email) as well for files with additonal attributes - both cause the error.

Clearing cookies or waiting for the system to "catch up" did not help with the speed - only removing the participants table did.

Integrity check did not show any problems with participants table.

Steps To Reproduce

Steps to reproduce

  1. Load participants from a csv file - ideally for 20k records or more
    2a. Try to go to another setting of the survey
    2b. Try to expand number of participants shown per page - 250 or more

Expected result

for 2a: going into a page of another option works smoothly
for 2b: it is possible to show up to 10k participants per page

Actual result

for 2a: loading the page takes 15 or more seconds
for 2b: trying to load more than 250 participant causes an error

TagsNo tags attached.
Attached Files
Slowness_appearance.PNG (59,556 bytes)   
Slowness_appearance.PNG (59,556 bytes)   
Error1.png (94,111 bytes)   
Error1.png (94,111 bytes)   
Error2.png (198,260 bytes)
Bug heat14
Complete LimeSurvey version number (& build)6.4.12
I will donate to the project if issue is resolvedNo
BrowserChrome, Microsoft Edge
Database type & versionMySQL 10.2.44-MariaDB - SUSE package
Server OS (if known)Linux www5 5.3.18-59.10-default #1 SMP
Webserver software & version (if known)
PHP Version7.4.6
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2024-03-18 16:43

developer   ~79800

Thanks for the report

for 2b: it is possible to show up to 10k participants per page

It's really related to the server here.

2a seems very strange

DenisChenu

DenisChenu

2024-03-18 16:51

developer   ~79801

I have a big server, but about 2A : seems related to the number of participant you shown ?

I don't see any difference with 10 participants shown (60 000 participants in database) , but showing 1000 participants : seems it take some time more on each action ?

DenisChenu

DenisChenu

2024-03-18 16:58

developer   ~79802

2 screencast : one with 10 and after 1000 token listed
One with 10 000 token liste : seems after load : there are a time for some script ???

https://gifyu.com/image/SUoRP
https://gifyu.com/image/SUoiz

joanna.hawrysz

joanna.hawrysz

2024-03-19 12:05

reporter   ~79806

Yes 2A seems to be because of how many participants are shown, but generally showing more participants causes other problems - aside from slowing the system it seems to crash the option for reminders and invites. It doesn't open the separate window and/or causes the errors I've shown.

c_schmitz

c_schmitz

2026-10-25 10:57

administrator   ~86771

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=41018

LimeBot

LimeBot

2026-10-26 13:51

administrator   ~86814

Fixed in Release 7.8.0+261026

Related Changesets

LimeSurvey: master d416112c

2026-10-25 10:57

c_schmitz


Details Diff
Fixed issue 19486: Showing many survey participants per page was very slow or failed with an error, and "View this participant in the central participants database" was enabled for participants not linked to it
Dev The menu entry condition counted the whole participant table once per grid row; it now checks the row's own participant_id
Affected Issues
19486
mod - application/models/TokenDynamic.php Diff File

Issue History

Date Modified Username Field Change
2024-03-18 13:52 joanna.hawrysz New Issue
2024-03-18 13:52 joanna.hawrysz File Added: Slowness_appearance.PNG
2024-03-18 13:52 joanna.hawrysz File Added: Error1.png
2024-03-18 13:52 joanna.hawrysz File Added: Error2.png
2024-03-18 16:43 DenisChenu Note Added: 79800
2024-03-18 16:43 DenisChenu Bug heat 0 => 2
2024-03-18 16:51 DenisChenu Note Added: 79801
2024-03-18 16:58 DenisChenu Note Added: 79802
2024-03-19 12:05 joanna.hawrysz Note Added: 79806
2024-03-19 12:05 joanna.hawrysz Bug heat 2 => 4
2025-09-23 10:50 guest Bug heat 4 => 10
2026-10-25 10:57 c_schmitz Changeset attached => LimeSurvey master d416112c
2026-10-25 10:57 c_schmitz Note Added: 86771
2026-10-25 10:57 c_schmitz Assigned To => c_schmitz
2026-10-25 10:57 c_schmitz Status new => resolved
2026-10-25 10:57 c_schmitz Resolution open => fixed
2026-10-25 10:57 c_schmitz Bug heat 10 => 12
2026-10-26 13:51 LimeBot Note Added: 86814
2026-10-26 13:51 LimeBot Status resolved => closed
2026-10-26 13:51 LimeBot Bug heat 12 => 14