[wp-hackers] Re: Changing MySQL minimum version

[Robert Deaton]

On 11/29/06, Matt Mullenweg <m at mullenweg.com> wrote:
> Austin Matzko wrote:
> > With the sub-query functionality introduced in MySQL 4.1, we could
> > easily use a sub-query to define what we're excluding.
>
> Sub-queries are pretty rough in 4.1, they're really not fast until
> 5.0/5.1. It's just blog software, we don't really need anything that fancy.

I think we need the ability to exclude multiple categories, and if
subqueries is the fancy item we need to achieve that without a nasty,
nasty query, then I think we need it. And do you have benchmarks or a
quantifiable difference between the 4.1 and 5.x? A few minutes of
searching produced nothing on the subject.

-- 
--Robert Deaton
http://lushlab.com