[wp-testers] 2.3 and loooooong running queries

Alexander Concha alex at buayacorp.com
Wed Oct 3 18:13:42 GMT 2007


Ryan Boren escribió:
> On 10/2/07, Handy <handy.solo at gmail.com> wrote:
>> [...]
> 
> That looks like a tag intersection query with 10 tags.  That will suck
> given how intersections are simulated by equating corresponding
> attributes.  If anyone knows a better way of doing intersections in
> MySQL 4.1, do tell.  Maybe we should just post-process a union.
> Regardless, WP should only do these queries when tag=foo+bar+baz+...
> is requested.

Tag intersections can be done using two queries, you can see an example
for tag_slug__and in http://pastebin.com/m38c901f3.

Regards

-- 
Alexander Concha
http://www.buayacorp.com/

La justicia es incidental a la ley y el orden
		-- J. Edgar Hoover.


More information about the wp-testers mailing list