| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Lukas Kahwe Smith <smith(at)pooteeweet(dot)org> |
| Cc: | pgsql-advocacy(at)postgresql(dot)org, Greg Smith <gsmith(at)gregsmith(dot)com> |
| Subject: | Re: PostgreSQL vs. MySQL: fight |
| Date: | 2007-08-03 18:01:45 |
| Message-ID: | 20070803180145.GT17022@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy |
On Fri, Aug 03, 2007 at 06:35:16PM +0200, Lukas Kahwe Smith wrote:
> Lukas Kahwe Smith wrote:
>
> >One major difference of MySQL is that it provides SQL hints. This
> >alleviates the issues with slow complex joins, but is obviously a
> >dangerous tool if not used wisely. That being said, it can often
> >be a very quick fix, whereas in PostgreSQL you do not have such
> >tools if you ever need them.
>
> One more thing...MySQL currently has horrible performance for sub
> selects. This will improve slightly in 5.1 and is scheduled to be
> "solved" with 5.2
Given MySQL AB's track record, I'll believe it when I see independent
confirmation.
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lukas Kahwe Smith | 2007-08-03 18:05:15 | Re: PostgreSQL vs. MySQL: fight |
| Previous Message | Alvaro Herrera | 2007-08-03 16:36:39 | Re: PostgreSQL vs. MySQL: fight |