[wp-hackers] Re: Changing MySQL minimum version

[Computer Guru]

Not to start a war or anything, but I think David's right. Ever since 1.5 WP
has become notorious for its rather in-efficient database. I'm NOT (let me
repeat: NOT) a database expert and all I know about MySQL is just how to
create a database that does the job. But I think there is something missing
from WP's database performance.

When you have forums like phpBB and IPB that can take up to 100 or more
times the load as WP _without caching_ and they serve quite a lot more
queries, I think that means something is wrong.

IMO, WP being inefficient at DB-querying is something that already happened,
and unless someone is volunteering to completely redo the database with full
optimizations and proper schemas taking advantage of all of MySQL's
(admittedly few) SQL-Side power tools, there's nothing to be done. But
ignoring these features for future changes and feature-sets is another
story...

Just my two cents..

Computer Guru
NeoSmart Technologies
http://neosmart.net/blog/

> -----Original Message-----
> From: wp-hackers-bounces at lists.automattic.com [mailto:wp-hackers-
> bounces at lists.automattic.com] On Behalf Of David Chait
> Sent: Thursday, November 30, 2006 7:59 PM
> To: wp-hackers at lists.automattic.com
> Subject: Re: [wp-hackers] Re: Changing MySQL minimum version
> 
> "It's just blog software, we don't really need anything that fancy."
> 
> That's the worst thing I've ever heard you say here.
> 
> WP is a competitive blogging (and CMS) platform.  It's being used not
> only
> for individual installations on shared servers (some with heavy usage),
> but
> bigger installs on dedi servers, all the way up to NYT and the like
> which
> are likely multi-server or at least heavy multi-processor boxes.  We're
> also
> seeing more use of it as CMS via Pages, and heavy multi-user
> installations
> like WP.com via WPMU.
> 
> Why wouldn't we want to take advantage of new (to MySQL, not to the
> rest of
> the SQL world...), higher-performing features like sub-queries, that
> can
> take load off BOTH the php box and the sql box?
> 
> With all the people who have to run WP-Cache2 in order to not have
> their
> provider take down their site for heavy php and sql use, with all the
> sites
> who live or die on the platform, we need every 'fancy' bit we can get.
> 
> -d
> 
> ----- Original Message -----
> From: "Matt Mullenweg" <m at mullenweg.com>
> To: <wp-hackers at lists.automattic.com>
> Sent: Wednesday, November 29, 2006 8:59 PM
> Subject: Re: [wp-hackers] Re: Changing MySQL minimum version
> 
> 
> > 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.
> 
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers