Hello, I have a client using Slim Stats and had their GoDaddy support team send them a message saying they had a DB query that was much too large. They cited the following code as the culprit.
`You will need to correct the following query:
INSERT INTO wp_slim_stats (
WHERE NOT EXISTS ( SELECT
ip = '404437658' AND
language = 'en-us' AND
country = 'us' AND
domain = 'urbanbushbabes.com' AND
referer = 'http://urbanbushbabes.com/' AND
searchterms = '' AND
resource = '/?page_id=1011' AND
visit_id = '623749' AND (TIME_TO_SEC(TIMEDIFF(FROM_UNIXTIME('1351853586'),FROM_UNIXTIME(
dt))) < 30) AND
browser_id = '2' LIMIT 1 )
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY No tables used
2 SUBQUERY wp_slim_stats ALL 1604794 Using where
This query examines 1,604,794 rows, which is unacceptable in shared hosting.
Any thoughts on what is doing this? Thanks!