Slow query?
-
Hi,
I’m having some server load issues, and my hosting provider was looking at our logs and noticed that that there was a long running query in the loadwatch logs.
They didn’t have the full query itself, but this is the snippet shown in loadwatch:
SELECT DISTINCT(relevanssi.doc), 1 AS term, 1 AS term_reverse,
1 AS content, 1 AS title, 1 AS commThey said some of these queries run longer than 100 seconds and could cause issues unless properly spaced.
Any suggestions, please? Thank you.
The topic ‘Slow query?’ is closed to new replies.