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 comm

    They said some of these queries run longer than 100 seconds and could cause issues unless properly spaced.

    Any suggestions, please? Thank you.

Viewing 16 replies (of 16 total)
Viewing 16 replies (of 16 total)
  • The topic ‘Slow query?’ is closed to new replies.