Slow SQL query

whu606

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

tester13

Disable Analytics :-)

whu606

tester

Thank you for responding, but it would have been a great deal more helpful if you had suggested how 'disabling analytics' were to be achieved.

There is nothing obvious in the dashboard regarding this, which is why I asked for help.

yu_tang

See below.
http://vanillaforums.org/docs/vanillastatistics#disabling-statistical-reporting

whu606

yu_tang

Thank you very much for that. That is just what I needed to know.