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?

Thanks
Tagged:

Comments

This discussion has been closed.