Thanks for the reply - the host also said it needs a where statement. I tried searching the code for the query but was unable to find it. I am using Drupal 5.9.
here's a list of modules currently "on": -- frontpage -- cck: content, content copy, fieldgroup, image, link, number, option widgets, text -- core-optional: blog, book, comment, forum, help, path, ping, profile, search, statistics, taxonomy -- core-required: all checked -- other: comment closer, comment notify, comment subjects, excerpt, feedback, forward, meta tags, mollom, openid, outbrain, page title, path auto, related links, search 404, spam, taxonomy introduction, tell a friend, tinymce, trackback, url list -- views: views, viewsrss, views theme wizard, views ui
Thanks!
-- Allen
Earnie Boyd wrote:
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/