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

[Allen Stern]

Thanks Greg, I appreciate the help - Just updated the module with your 
birthday edition. Let's hope this fixes the issue!

-- Allen

allen at centernetworks.com wrote:
> -----Original Message-----
> From: "Greg Knaddison - GVS" <Greg at growingventuresolutions.com>
> Sent: Wednesday, October 29, 2008 11:19am
> To: support at drupal.org
> Subject: Re: [support] Issue with a Query that's running wild
>
> On Tue, Oct 28, 2008 at 4:15 PM, Allen Stern <allen at centernetworks.com> wrote:
>   
>> My hoster is telling me that the query below is processing 52 million
>> records every time it's run.
>>     
>
> It shouldn't be run very often...
>
>   
>> Any ideas on where this query is, what it
>> does or how to fix it would very much be appreciated.
>>     
>
> That's a query from Pathauto that is used to do the "bulk update" of
> aliases.  It only runs when you do a "bulk update" which is a
> maintenance procedure that should only be run if you change your
> Pathauto patterns or install Pathauto on an existing site that had a
> lot of content without aliases.
>
>   
>> I have not changed
>> anything in the installation in forever.
>>     
>
> Apparently you haven't ;)  The performance of this query was improved
> in the version of Pathauto released on June 26th (my birthday, so I
> remember it well).
>
> Regards,
> Greg
>
>   

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