[wp-testers] 2.3 and loooooong running queries

Charles E. Frees-Melvin charles.freesmelvin at gmail.com
Fri Oct 5 11:55:23 GMT 2007


Depending on the other navigation on yor site it might be benificial to not
allow robots to the /tag/ pages in .htaccess that is what I did.

On 05/10/2007, Les Bessant <les at lcb.me.uk> wrote:
>
> > -----Original Message-----
> > From: wp-testers-bounces at lists.automattic.com [mailto:wp-testers-
> > bounces at lists.automattic.com] On Behalf Of Handy
> > Sent: 05 October 2007 06:08
> > To: wp-testers at lists.automattic.com
> > Subject: Re: [wp-testers] 2.3 and loooooong running queries
> >
> > On 10/4/07, Handy <handy.solo at gmail.com> wrote:
> > >
> > >
> > > C) Ignoring B, why is that query causing all subsequent queries to go
> > into
> > > a "locked" state? That's really the crux of the matter.  The query
> > that
> > > results from that hit clobbers my database and runs forever, blocking
> > all
> > > other queries.  Theme/plugin be darned!
> > >
> > >
> > I grabbed the query.php from
> > http://trac.wordpress.org/browser/branches/2.3/wp-
> > includes/query.php?rev=6187
> >
> > Now, the former db killer results in a 404.  For the moment, I find
> > that
> > much more acceptable. Other more rational tag unions seem to work.
>
> Just had a look at my logs, and I had a similar search query:
>
> 65.88.178.10 - - [02/Oct/2007:01:16:22 -0700] "GET
>
> /losingit/tag/It%20looks%20like%20a%20slightly%20squeezed%20foil%20packet%20
> of%20something%20or%20other.%20Makes%20some%20great%20reflections.
> HTTP/1.1"
> 200 2748 "http://lcb.me.uk/losingit/tag/colour_of_magic"
> "my-heritrix-crawler(+http://mywebsite.com)"
>
> Repeated several times....
>
> I've grabbed query.php, too.
>
> Thanks to all :)
>
>
>
> Les Bessant les at lcb.me.uk
> Losing it[1] - http://lcb.me.uk
> My flickr pictures - http://flickr.com/photos/lesbessant/
>
>
>
>
>
> _______________________________________________
> wp-testers mailing list
> wp-testers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-testers
>



-- 
--------------------------------
Charles E. Frees-Melvin
charles.freesmelvin at gmail.com
www.cefm.ca


More information about the wp-testers mailing list