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

Re: DBD::Pg performance bites compared to DBD::mysql?

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: DBD::Pg performance bites compared to DBD::mysql?
Date: 2005-06-14 03:04:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
Hash: SHA1
>> the above trace only shows a factor of 2 total penalty, but I've
>> seen up to a factor of 4 in other cases.  There is no way that a
>> client-side driver should be taking several times longer than the
>> backend to process a SQL command :-(

> What version of DBD::Pg did you test with?

This is a problem with the newer versions as well. Maybe even worse,
as we had to do some contortions when the PQprepare 7.4/8.0 mess
appeared. However, we can definitely speed up that part of the code.
I'll see about doing this soon.

I still maintain the original test is brain-dead, however. :) It was
testing for "insert speed" by basically doing this:

for (1..1000) {
        $dbh->do("INSERT INTO testtable(a,b) VALUES (1,2)");

It's as if the people who wrote it *cough*mysql*cough* never heard
of prepare/execute and did not read the DBI docs.

It's very similar to the script on this page:

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200506121438


In response to


pgsql-interfaces by date

Next:From: Greg StarkDate: 2005-06-14 06:44:28
Subject: Re: DBD::Pg performance bites compared to DBD::mysql?
Previous:From: Francisco Figueiredo Jr.Date: 2005-06-14 01:37:01
Subject: Re: Problem while using Refcursors in Postgres with

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