[wp-hackers] Re: Changing MySQL minimum version

[David Chait]

Some quick performance tests could answer this... it might be that 
subqueries don't really cause a performance hit (might even still improve 
performance) under 4.x versus current multi-query approaches.

-d

----- Original Message ----- 
From: "Michael Gall" <michael at wakeless.net>
To: <wp-hackers at lists.automattic.com>
Sent: Thursday, November 30, 2006 1:57 AM
Subject: Re: [wp-hackers] Re: Changing MySQL minimum version


> Think of it as future proofing... People are going to be running on 5.0 
> and
> 5.1 anyway, why not let them get the full benefit of the subqueries, and 
> the
> guys on 4.1 just have the small performance hit when (and hopefully not
> often) one is used.
>
> On 11/30/06, Viper007Bond <viper at viper007bond.com> wrote:
>>
>> And even if it slower performing, slow performance for the occasional
>> query
>> is a lot better than none at all.
>>
>>
>> > > 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.
>>
>>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>