[wp-testers] 2.3 and loooooong running queries

[Les Bessant]

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