Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Slow SQL query

whu606whu606 I'm not a SuperHero; I just like wearing tights... MVP
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.