More in this section
Forums / Developing with Sitefinity / Optimizing Queries

Optimizing Queries

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
2 posts, 0 answered
  1. Matt
    Matt avatar
    1 posts
    17 Sep 2015
    14 Oct 2015
    Link to this post

    We have a couple of pages that are running particularly slow. When look at the pages using the Diagnostics Module, it is showing, for instance, on one page that a certain query is taking between 2 and 9 seconds every time the page is hit. The query is hitting the sf_lic_user_activity table. Is there a setting I'm missing? What can I do to try and optimize these sorts of queries? Is this a caching problem? 

     I'm new to Sitefinity so any guidance that anyone can provide would be greatly appreciated.

  2. Junior Dominguez
    Junior Dominguez avatar
    115 posts
    15 Sep 2017
    19 Oct 2015
    Link to this post
    Hi Matt,

    Are you using any custom widget on those pages ? Note that the sf_lic_user_activity keeps record of the user status (for instance whether the user is online or not).

    You can also consider the following tips to improve the performance of your site in general:

    Best Regards,
    Junior Dominguez
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
2 posts, 0 answered