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.