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

[Allen Stern]

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 at 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/
>
>   

-- 
Allen Stern - CenterNetworks
http://www.centernetworks.com

Have you subscribed to our RSS Feed?
http://feeds.feedburner.com/Centernetworks-

Press release service:
http://www.centernetworks.com/pressreleases

Post your job openings:
http://www.centernetworks.com/job-posting-info