View Issue Details

This bug affects 1 person(s).
IDProjectCategoryView StatusLast Update
19486Bug reportsSurvey participants (Tokens)public2024-03-19 12:05
Reporterjoanna.hawrysz Assigned To 
Status newResolutionopen 
Product Version6.4.x 
Summary19486: Slowness and errors when working on a survey with loaded participants

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 heat4
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

Users monitoring this issue

There are no users monitoring this issue.




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



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 ?



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 ???



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.

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