Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Database Queries Being Executed Multiple Times

More
15 hours 38 minutes ago #271457 by jcpgspr
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.

Please Log in to join the conversation.

More
8 hours 34 minutes ago #271463 by holch
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.

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.

Please Log in to join the conversation.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose