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.

Thank you for your assistance.

What do you mean with "list survey page"?

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.

Id to not create assets file multiple time.
It's with a different `:path` each time (else we can easily improve).

Move this system to a cache can be great. Maybe can report issue ?