Re: [support] Issue with a Query that's running wild

Quoting Allen Stern allen@centernetworks.com:

My hoster is telling me that the query below is processing 52 million records every time it's run. Any ideas on where this query is, what it does or how to fix it would very much be appreciated. I have not changed anything in the installation in forever. The host thinks that the more content I write, somehow the query was pushed over the limit for warnings.

QUERY: SELECT n.nid, n.type, n.status, n.promote, n.changed, u.dst FROM node n LEFT JOIN url_alias u ON u.src=CONCAT('node/',n.nid)

This query needs a "WHERE n.nid = %d" added to it. What version of Drupal? What modules?

Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/