| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Sebastian Hennebrueder" <usenet(at)laliluna(dot)de> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL vs MySQL, and FreeBSD |
| Date: | 2007-11-09 15:57:33 |
| Message-ID: | dcc563d10711090757jeaa7ed2h962d79fe948fcad6@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Nov 9, 2007 9:41 AM, Sebastian Hennebrueder <usenet(at)laliluna(dot)de> wrote:
> If the queries are complex, this is understable. I had a performance
> review of a Hibernate project (Java Object Relation Mapping) using
> MySQL. ORM produces easily "complex" queries with joins and subqueries.
> MySQL uses nested loops for subqueries which lead to performance issues
> with growing database size.
>
> They state in their documentation that for version 5.2 there are
> improvements planned regarding this kind of query.
So, MySQL 5.2 will be catching up to version 7.1 or 7.2 of PostgreSQL
in that regard?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jurgen Haan | 2007-11-09 16:01:08 | Re: dell versus hp |
| Previous Message | Erik Jones | 2007-11-09 15:50:47 | Re: PostgreSQL vs MySQL, and FreeBSD |