Please help us help you and fill where relevant: LimeSurvey version: 6.6.3 Own server or LimeSurvey Cloud: Own server Survey theme/template: Fruity
==================
Hi!
We are currently working on resolving some performance issues with our implementation of LimeSurvey. To address these, we are examining the queries being executed on the list survey page. We have enabled debugsql and are reviewing the list of queries generated with each page load.
During our investigation we observed that a particular query is being executed multiple times consistently across different trials. On average, this query runs over 35 times per page reload.
SELECT TOP 1 * FROM [dbo].[lime_asset_version] [t] WHERE path = :path
As part of our ongoing efforts to improve on performance, we would like to confirm whether this query count is expected behavior.
For me, the list survey page in Limesurvey language is basically the "index" page that you see when you go to your limesurvey installation, but not to the admin, where the publicly listed surveys are shown.
This page should be accessed pretty infrequently, thus the impact on performance of your installation should be minimal.
Or are you talking about the admin page where all surveys are listed to those with access to the backend?
But over 35 times the same query sounds strange to me, too. However, I am not a developer. So let's see if someone from the development team sees this (they generally do not visit the forum very frequently though).
In any way, I think it would be good if you could specify which page you exactly mean to avoid confusion.
Help us to help you!
Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.