Re: Advantages of PostgreSQL over MySQL 5.0

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Advantages of PostgreSQL over MySQL 5.0
Date: 2006-03-24 06:19:17
Message-ID: e0037g$1pbc$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


""Merlin Moncure"" <mmoncure(at)gmail(dot)com> wrote
>
> In postgresql, queries executed over the parameterized/prepared C api
> are particularly fast...as much as a 70% speed reduction over vanilla
> PQexec.

Does it mean 70% time is spent on planning? I am a little bit interested in
this number. Can you specify what kind of queries or give some testing
numbers. By the way, if so, we can do it by PREPARE statement in SQL.

Regards,
Qingqing

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oisin Glynn 2006-03-24 06:22:29 Re: PostgreSQL 8.1 v. Oracle 10g xe
Previous Message Steve Atkins 2006-03-24 06:10:31 Parallel sequential scans