Please help us help you and fill where relevant: LimeSurvey version: LimeSurvey Community Edition Version 6.3.8+231204 Own server or LimeSurvey Cloud: Own Server Survey theme/template: fruity_twentythree
==================
We're running LimeSurvey since almost 2 years on Kubernetes with a pod for LimeSurvey and another pod running PostgreSQL 16.1.
It's never been super-fast but recently I recognized that - no matter which action I take - it is slowly responding. If we run larger surveys with e.g. 20-50 users it can influence the user experience in loading the next survey page and people just don't want to complete it.
However, this is also when I look at survey results or navigate on the admin screen. Just not snappy. It runs very stable, though, no crashes or errors. We have around 400 surveys in the DB and 70 users. The delays show also when I'm the only user of the system (no concurrent activities).
Any pointer where/ how I can start analyzing on what the time is spent?
It's never been super-fast but recently I recognized that - no matter which action I take - it is slowly responding.
You run a complex stack. What changed recently? Since you haven't updated LimeSurvey for a while LimeSurvey seems to be not the root cause.
I would start creating two pods for LimeSurvey and DB and look if a fresh installation would have the same performance issues.
My first guess would be that the postgresql pod changed recently and the performance bottleneck is laying there. Perhaps you clone the db pod and try it with a different webapp to see if the performance issues are the same.
Not sure if we have many forum users running your kind of stack. Good luck finding the root cause.
