Users running a non-download version of Vanilla (pulled from github), on branch release/2019.016 or master from the last 2 weeks should upgrade to release/2019.017 or latest master for security reasons. Downloaded official open sources releases are not affected.
Please upgrade here. These earlier versions are no longer being updated and have security issues.

Slow SQL query

whu606whu606 I'm not a SuperHero; I just like wearing tights... Moderator
edited February 2011 in Vanilla 2.0 - 2.8
Trying to address issues with page loading time on my site, I found the following regularly causes a slow SQL query:

# Sun Feb 27 01:52:13 2011
# Query_time: 2.779903 Lock_time: 0.000118 Rows_sent: 0 Rows_examined: 0
use SITE_vnl1;
insert into GDN_AnalyticsLocal (TimeSlot, Views) values ('20110227', 1)
on duplicate key update Views = Views+1

Does anyone know what this query does, or what it is part of?

If you do, is there anything I can do to improve the speed of the query?



This discussion has been closed.