Optimizing Queries

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.

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:

docs.sitefinity.com/best-practices-optimize-performance

​http://www.sitefinity.com/blogs/slavoingilizov/posts/slavo-ingilizovs-blog/2012/03/14/5_practices_to_avoid_when_doing_sitefinity_development

http://docs.sitefinity.com/recommended-environment-settings


Best Regards,
Junior Dominguez
Telerik