Skip site navigation (1) Skip section navigation (2)

give a hand to a user having trouble with MySQL?

From: "Wenjian Yang" <wenjiany(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-advocacy(at)postgresql(dot)org
Subject: give a hand to a user having trouble with MySQL?
Date: 2008-02-25 19:46:25
Message-ID: bf9d6a9e0802251146i72750da4ve47ab87613ea68cb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-general
Came across a blog from Ovid, one of the Perl gurus at BBC.
http://use.perl.org/~Ovid/journal/35752?from=rss

Quote

"They're not kidding, either. Subquery optimization in MySQL is terribly
broken<http://www.xaprb.com/blog/2006/04/30/how-to-optimize-subqueries-and-joins-in-mysql/>,
as we've discovered today. We have Matt Trout in for some consulting and
even ridiculously stupid subqueries have terrible query plans, forcing us to
to consider nasty workarounds, one of which is called "PostgreSQL"."

Even though he counts PostgreSQL as one of th enasty workarounds, maybe we
should give them a helping hand?

Wenjian

pgsql-advocacy by date

Next:From: Andreas 'ads' ScherbaumDate: 2008-02-27 14:12:39
Subject: Re: pg_live situation update
Previous:From: Magnus HaganderDate: 2008-02-25 16:21:07
Subject: Re: Report FOSDEM (Brussels) 2008

pgsql-general by date

Next:From: AndrusDate: 2008-02-25 19:47:58
Subject: Re: Use index for upper(customername) like 'ABC%'
Previous:From: Tom LaneDate: 2008-02-25 19:17:33
Subject: Re: text and bytea

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group